nested if statement

pprice11

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!!

GrantSmith

@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

jaeW_at_Onyx

=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)