need HELP on a formula

B

Brian

I am subtracting one cell from another, but i don't want
it answer to go into the negatives. If the answer is
negative, i want it to be zero. any help out there for
me?
 
D

Dan Sprouse

Just a thought, but could you use the If statement, for
example--

If (a1-a2>0, a1-a2, 0)

This should give you the difference between a1 and a2 if
the difference is greater than zero. Otherwise, it should
return a zero.

Hope this helps,

-Dan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Program buttons to create a word document 0
Newbie Help - IF Yes No Function 0
Subtracting positive amts from negative and positive from positive 3
Rounding Negative Numbers to Zero 4
Divide two cells and if the number is negative display is as zero 2
How do I limit formula results to positive only? 4
Error in subtracting times 2
formula to a minimum value of zero if a negative number 2

Top