# 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

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

you could start the if statement with that

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

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.

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

Thanks guys. works perfectly!!!

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

I'm also twin. lol.

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1