ZERO VALUE NOT WORKING

[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!!!

 

[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)

 

[Guest]

EUREKA! THANX

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)