pprice11

Discussions

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!!
Can i write a nested "if" "and" statement in beast mode?
here is what the excel formula looks like: =IF(AND(K5=0,L5=0),"remaining",IF(AND(K5=0,L5>0),"resolved",IF(AND(K5>0,L5>0),"no gap","new"))) thank you so much for your help