Excel quick question

[importdistributors]

Hello, I have a quick question for anyone who has knowledge in excel/vba. I need to make a cells results stay positive or zero, If the cell comes up to be a negative number, I want it to automatically say zero. Thanks in advance.

 

[JS80]

a simple if statement should do it...

 

[AtlantaBob]

=if(val<0,0,val) should do the trick....
that is, if val <0, then cell = 0; otherwise, it's equal to the value entered.

 

[LegendKiller]

Yeah, thats pretty simple. =IF(C8<0, 0, C8)

 

[TuxDave]

Example:
=MAX(A4,0)

Basically this will display the higher of the two numbers. The number in cell A4 and 0.

 

[importdistributors]

Awsome, So there is no specific format cell method that can do that?

 

[AtlantaBob]

Nope, you'd have to use either the IF() method or Dave's MAX() method; however, if you're using this for multiple cells, enter the format in the first one and then use fill down, or fill right and it'll automatically adjust the input values for you.

 

[LegendKiller]

Originally posted by: importdistributors
Awsome, So there is no specific format cell method that can do that?

Not that I know of.

 

[importdistributors]

Excellent. Thank you all so very much. you saved me tonz of time. Gratitude!

 

[joecool]

ps - try the excel help next time. it really works!