Forum Discussion
erin-5304
Nov 28, 2022Brass Contributor
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