nested if statement

I am trying to write a beast mode that would replace the following nested if statement out of excel:

 

=IF(I8121="Total SS",M8121*12,IF(I8121="Total PODZ",M8121*12,IF(I8121="Total 5+1 ",M8121*2,IF(I8121="Total 3 Pack",M8121*4,IF(I8121="Club Pack",M8121*360)))))

 

how would I format that beast mode?

 

thank you for your help!!

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    @pprice11 

    CASE statements are your friend.

    CASE
    WHEN I8121="Total SS" THEN
        M8121*12
    WHEN I8121="Total PODZ" THEN
        M8121*12
    WHEN I8121="Total 5+1 " THEN
        M8121*2
    WHEN I8121="Total 3 Pack" THEN
        M8121*4
    WHEN I8121="Club Pack" THEN
        M8121*360
    END
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • =IF(I8121="Total SS",M8121*12,IF(I8121="Total PODZ",M8121*12,IF(I8121="Total 5+1 ",M8121*2,IF(I8121="Total 3 Pack",M8121*4,IF(I8121="Club Pack",M8121*360)))))

     

    Take a look at CASE statements.

    (just google CASE SQL statement)

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • GrantSmith
    GrantSmith Coach
    Answer ✓

    @pprice11 

    CASE statements are your friend.

    CASE
    WHEN I8121="Total SS" THEN
        M8121*12
    WHEN I8121="Total PODZ" THEN
        M8121*12
    WHEN I8121="Total 5+1 " THEN
        M8121*2
    WHEN I8121="Total 3 Pack" THEN
        M8121*4
    WHEN I8121="Club Pack" THEN
        M8121*360
    END
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**