Negative value and zero

  • Thread starter Thread starter **{Steven}**
  • Start date Start date
S

**{Steven}**

If I have a negative value and I want other equations to use that negative
value but I want to cell to show a 0 whenever there is a negative, how do I
formulate that?

Thanks In Advance

Steven Connor
 
Fornat>Cells>Custom. In the Type box, enter #,##0;"0" or some other format,
as long as the part after the semicolon is a zero between quotes

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Steven, or with a formula

=IF(A1+B1>0,A1+B1,0)
=IF(A1+-8>0,A1+-8,0)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Your reply seems to hold the answer to my problem, but I don't quite
understand exactly what you mean. Right now, I use =I24*G5 which is a loan
amount, multiplied by a percentage. If the percentage becomes negative, I
need other calculations to still have access to the negative value of that
cell but when I look at it, or print it up. I want it to show 0 instead of
the actual negative value. Do I use symbols, as you have or do they stand
for number in my cell?

TIA

Steven
 
Back
Top