IF Function Excel 2002

M

MarkC

Hello, and hope I explained my situation clearly:

I have entered =IF(B4<3,"<3",B4). Applying the formula will have the
effect, any number less than 3 will show <3 in the cell, any number greater
than 3 will keep the value. So if I have 2 in a cell, the cell will show
<3, and if the cell has 6.0 it will show 6.0. I want to go a step further,
and if the cell has 0 (zero), I want 0 (zero) to show up, not <3. Is it
possible?

Example:
If the cell has 5, like it to show 5.
If the cell has 2, like it to show <3.
If the cell has 0, like it to show 0 (zero).

Thanks,

M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
AND IF STATEMENT 1
Excel Need Countifs Formula Help 0
Displaying zeros in cells 2
adding rows into the table 1
help on a formula (match and etc..) 1
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Show other cell if blank 5

Top