greater than formula

[moorecountytax]

I need to know a formula that will make a cell automatically go to 0.0
if the result would be a negative number. I have racked my brain al
morning & still can't figure it out!!!!!!!!!!!

 

[Niek Otten]

=MAX(YourPresentFormula,0)

--
Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[cmoore]

if cell a1 contains the number use this equation

=if(a1<0,0,a1

 

[moorecountytax]

Thank you so much for your help. It worked perfectly!!!