Nesting IF and IFNA

[Mr_Smit]

Hi guys,

is it possible to nest IFNA and IF. Basically what I've got now

=IFNA(R109,O109),IF(C109="Beer",C109*24,"")

and in another column i've tried

=IF(U109="","No Data",IF(C109="Beer",C109*24,IF(S109+S109*0.2>=U109+V109,"Order","")))

this just returns #VALUE?.

All i want is if the cell equals beer times it by 24, before it delivers the order signal. So write now its using cases and not returning order when it should. Otherwise I'll have to add another column etc. and it's just becoming too slow.

Thanks for any help everyone.

 

[Mr_Smit]

Just to add another question while we're at it. which is better?

=IF(U17="","No Data",IF(SUM(S17,S17*0.2)>=SUM(U17,V17),"Order",""))

or

=IF(U18="","No Data",IF(S18+S18*0.2>=U18+V18,"Order",""))

they're both trying to accomplish the same thing (i hope!). is one better than the other?