## nested if statement

Highlighted White Belt

## 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?

Accepted Solutions
Highlighted Brown Belt

## Re: nested if statement

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

**Did this solve your problem? Accept it as a solution!**

All Replies
Highlighted Major Red Belt

## Re: nested if statement

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

Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Highlighted Brown Belt

## Re: nested if statement

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