Forum Discussion

erin-5304's avatar
erin-5304
Brass Contributor
Nov 28, 2022

FORMULAS WITH MULTIPLE IF SCENERIOS

I am trying to write a formula for the following situation:

 

IF(C18="WW-1",9750 or IF(C18="WW-2",5200 or IF(C18="WW-3",5200 or if WW-1,2,3 are in C18 and there are numbers in I18 and J18 then add those together for the total.

 

I am trying this formula and it only shows #VALUE, any tips?

 

IF(C18="WW-1",9750),IF(AND(C18="WW-2",5200),IF(AND(C18="WW-2",5200),IF(ISNUMBER(I18),I18+J18),"")

 

No RepliesBe the first to reply

Resources