How to Add 1 more criteria to this IF function

[thewiseguy]

Hi All,

Here is my current formula:

=IF(R4="Yes",S4,IF(O4="Lamp",Helper!G5*Input!I4,Input!I4))

I would like to add 1 more criteria to this: If Q4="No Measure", "0"

Any help would be greatly appreciated!

 

[SunnyAlv]

Like this ?

=IF(R4="Yes",S4,IF(O4="Lamp",Helper!G5*Input!I4,IF(Q4="No Measure","0",Input!I4)))

 

[Cubist]

Try IFS to avoid the nested IF:

=IFS(Q4="No Measure", 0, R4="Yes", S4, O4="Lamp", Helper!G5 * Input!I4, TRUE, Input!I4)

 

[thewiseguy]

these both work perfectly. thank you both.