How to hide negative value view (eg: #######)
 

In a cell that already has an IF formula in it, how do I hide any negative
answer so as to show 0:00 (time) or at least blank?

How to hide negative value view (eg: #######)
 

Hi Dags,

Maybe wrap your formula like this
=MAX(your formula,0)

HTH
Martin

"Dags" wrote in message
...
In a cell that already has an IF formula in it, how do I hide any negative
answer so as to show 0:00 (time) or at least blank?

How to hide negative value view (eg: #######)
 

Format the cell as hh:mm;

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Dags" wrote in message
...
In a cell that already has an IF formula in it, how do I hide any negative
answer so as to show 0:00 (time) or at least blank?