Conditional formula (subtraction)

I am in need of a "subtraction" formula =a1-b1. The problem is I need excel to return either a whole number, when possible, if not return zero. Using the above formula excel returns a negative number. I am certain this is simple for some users but I just cannot find the correct formula to use. Lastly if the number result should increase where b1 is larger than a1 is it possible that excel can add the two?

there are 2 code for your needs:

Please Login or Register  to view this content.

Dear dklein2149,
You can use "If" for your condition.

=if(b1>a1,b1+a1,a1-b1).

That mean, if b1 is greater than a1, the result will b1+a1, else the result will a1-b1. So if a1=b1, it result will be "0".

Hoping this can help you,
YKnet

Thank you, the formulas worked. they add, subtract and return zero as I need the formula to do. Thanks again.