IF Function Excel 2002

  • Thread starter Thread starter MarkC
  • Start date Start date
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
 
Back
Top