Hide Negative Numbers or Display as Zero
 

I'm using Excel 2007 and can't figure out how to hide Negative Numbers or
dispay them as Zero. I'm making a timesheet and this is the formula I'm
using: =IF(ISTEXT(C10),D10,D10-C10)*24. When C10 is not text and I enter
8:00, F10 shows as -8.00. How can I hide this or display it as Zero until I
enter a value in D10?

Hide Negative Numbers or Display as Zero
 

Try this:

=IF(D10="","",IF(ISTEXT(C10),D10,D10-C10)*24)

will display a blank if D10 is blank.

Hope this helps.

Pete

On Oct 24, 1:34 am, Me wrote:
I'm using Excel 2007 and can't figure out how to hide Negative Numbers or
dispay them as Zero. I'm making a timesheet and this is the formula I'm
using: =IF(ISTEXT(C10),D10,D10-C10)*24. When C10 is not text and I enter
8:00, F10 shows as -8.00. How can I hide this or display it as Zero until I
enter a value in D10?

Hide Negative Numbers or Display as Zero
 

Don't know if this applies to 2007, but try condtional formatting, with value
less than or equal to zero:

Set the font color equal to the background color.
--
Gary''s Student - gsnu200750


"Me" wrote:

I'm using Excel 2007 and can't figure out how to hide Negative Numbers or
dispay them as Zero. I'm making a timesheet and this is the formula I'm
using: =IF(ISTEXT(C10),D10,D10-C10)*24. When C10 is not text and I enter
8:00, F10 shows as -8.00. How can I hide this or display it as Zero until I
enter a value in D10?

Hide Negative Numbers or Display as Zero
 

I thought of that but I was hoping there was a formula or option I could set
such as hiding zero values. If all else fails this is what I'll do. Thanks!

"Gary''s Student" wrote:

Don't know if this applies to 2007, but try condtional formatting, with value
less than or equal to zero:

Set the font color equal to the background color.
--
Gary''s Student - gsnu200750


"Me" wrote:

I'm using Excel 2007 and can't figure out how to hide Negative Numbers or
dispay them as Zero. I'm making a timesheet and this is the formula I'm
using: =IF(ISTEXT(C10),D10,D10-C10)*24. When C10 is not text and I enter
8:00, F10 shows as -8.00. How can I hide this or display it as Zero until I
enter a value in D10?

Hide Negative Numbers or Display as Zero
 

Nope, didn't work. I even tried this formula:
=IF(D10<0,0,IF(ISTEXT(C10),D10,D10-C10))*24 and still doesn't work. If I
can't figure it out I'll just use conditional formatting and set font and
background as white unless it's over 0. Thanks for the response!

"Pete_UK" wrote:

Try this:

=IF(D10="","",IF(ISTEXT(C10),D10,D10-C10)*24)

will display a blank if D10 is blank.

Hope this helps.

Pete

On Oct 24, 1:34 am, Me wrote:
I'm using Excel 2007 and can't figure out how to hide Negative Numbers or
dispay them as Zero. I'm making a timesheet and this is the formula I'm
using: =IF(ISTEXT(C10),D10,D10-C10)*24. When C10 is not text and I enter
8:00, F10 shows as -8.00. How can I hide this or display it as Zero until I
enter a value in D10?

Hide Negative Numbers or Display as Zero
 

Try this :

=IF(D10=0,"",IF(ISTEXT(C10),D10,D10-C10)*24)


"Me" wrote:

I'm using Excel 2007 and can't figure out how to hide Negative Numbers or
dispay them as Zero. I'm making a timesheet and this is the formula I'm
using: =IF(ISTEXT(C10),D10,D10-C10)*24. When C10 is not text and I enter
8:00, F10 shows as -8.00. How can I hide this or display it as Zero until I
enter a value in D10?

Hide Negative Numbers or Display as Zero
 

Try this :

=IF(D10=0,"",IF(ISTEXT(C10),D10,D10-C10)*24)

HTH

"Me" wrote:

I'm using Excel 2007 and can't figure out how to hide Negative Numbers or
dispay them as Zero. I'm making a timesheet and this is the formula I'm
using: =IF(ISTEXT(C10),D10,D10-C10)*24. When C10 is not text and I enter
8:00, F10 shows as -8.00. How can I hide this or display it as Zero until I
enter a value in D10?

Hide Negative Numbers or Display as Zero
 

Do you need to use the zero in calculations? If not, use this number
format to display zero:

0;"0"

or this number format to display blank:

0;""


On Oct 23, 8:34 pm, Me wrote:
I'm using Excel 2007 and can't figure out how to hide Negative Numbers or
dispay them as Zero. I'm making a timesheet and this is the formula I'm
using: =IF(ISTEXT(C10),D10,D10-C10)*24. When C10 is not text and I enter
8:00, F10 shows as -8.00. How can I hide this or display it as Zero until I
enter a value in D10?

Hide Negative Numbers or Display as Zero
 

No need for the quotations for blanks

0;


will do


--


Regards,


Peo Sjoblom


"ilia" wrote in message
oups.com...
Do you need to use the zero in calculations? If not, use this number
format to display zero:

0;"0"

or this number format to display blank:

0;""


On Oct 23, 8:34 pm, Me wrote:
I'm using Excel 2007 and can't figure out how to hide Negative Numbers or
dispay them as Zero. I'm making a timesheet and this is the formula I'm
using: =IF(ISTEXT(C10),D10,D10-C10)*24. When C10 is not text and I enter
8:00, F10 shows as -8.00. How can I hide this or display it as Zero until
I
enter a value in D10?