Hey,
This may be a bit of an easy one, but for some reason i can't seem to work it out.
i have a formula that says:
=IF(J23>=10,"PROCESS ORDER / PROVIDE STAND",IF(J23<=9,"PLS REVISE ORDER / CANCELLED",IF(J23=0,"")))
All worked well unitl i enter the last bit: IF(J23=0,"")
It seems that the <=9 includes the number 0 and then overrides the following comand.
How would i change this so that when J23 brings back a 0, the cell is left blank?????
Thanks
Bookmarks