# IF formula containing >=, <= & =

1. ## IF formula containing >=, <= & =

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  Register To Reply

2. ## Re: IF formula containing >=, <= & =

you could start the if statement with that

Formula:  `Please Login or Register  to view this content.`  Register To Reply

3. ## Re: IF formula containing >=, <= & =

Try this:

=IF(J23=0,"",IF(J23<=9,"PLS REVISE ORDER / CANCELLED","PROCESS ORDER / PROVIDE STAND"))

- Moo

* Looks like vlady beat me to a similar solution.   Register To Reply

4. ## Re: IF formula containing >=, <= & =

Thanks guys. works perfectly!!!  Register To Reply

5. ## Re: IF formula containing >=, <= & =

I'm also twin. lol.  Register To Reply

6. ## Re: IF formula containing >=, <= & =

LOL, vlady.   Register To Reply