ZERO VALUE NOT WORKING


G

Guest

The number format is 0.00. The font format is arial /bold /dark red.

The cell contains a rather complex formula (for me)
=IF(O21="FLEX",V21,IF(O21="HOLIDAY",V21,IF(O21="flexpart",0,AL6)))

I have been to tools/options/view and "unclicked" zero values. Still shows
0.00.

I tried a conditional format:
cell value equal to 0 / format font white

I can't get the darned 0.00 NOT to display no matter what I try.

HELP!!!
 
Ad

Advertisements

G

Guest

As a guess your formula is not returning Zero (probably a very small
decimal). Perhaps try rounding the result...

=round(IF(O21="FLEX",V21,IF(O21="HOLIDAY",V21,IF(O21="flexpart",0,AL6))), 3)
 
Ad

Advertisements

G

Guest

EUREKA! :) THANX

Jim Thomlinson said:
As a guess your formula is not returning Zero (probably a very small
decimal). Perhaps try rounding the result...

=round(IF(O21="FLEX",V21,IF(O21="HOLIDAY",V21,IF(O21="flexpart",0,AL6))), 3)
 

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

Top