ZERO VALUE NOT WORKING
 

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="fl expart",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!!!

ZERO VALUE NOT WORKING
 

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(O 21="flexpart",0,AL6))), 3)
--
HTH...

Jim Thomlinson


"Gator Girl" wrote:

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="fl expart",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!!!

ZERO VALUE NOT WORKING
 

EUREKA! :) THANX

"Jim Thomlinson" wrote:

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(O 21="flexpart",0,AL6))), 3)
--
HTH...

Jim Thomlinson


"Gator Girl" wrote:

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="fl expart",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!!!