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
Anne Troy - 19 Jan 2006 00:29 GMT
=IF(B4=0,0,IF(B4<3,"<3",B4))
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
> Hello, and hope I explained my situation clearly:
>
[quoted text clipped - 13 lines]
>
> M
MarkC - 19 Jan 2006 00:40 GMT
Thank You very very much Anne. That was it!
M
> =IF(B4=0,0,IF(B4<3,"<3",B4))
>
[quoted text clipped - 20 lines]
>>
>> M
Anne Troy - 19 Jan 2006 02:29 GMT
You're welcome!
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
> Thank You very very much Anne. That was it!
> M
[quoted text clipped - 23 lines]
>>>
>>> M