Subtracting (a better explanation I hope)

S

Skip

Cell A1 50
Cell A2 100
I would like to subtract the two cells, with only the positive number
appearing
in the next column next to the larger number

Cell b1 =(a1-a2) answer -50, but I would like the cell not to show
-50, I would like it empty
cell b2 =(a2-a1) answer 50, and i want the 50 to appear in b2.

What can I add to my formulas?

I hope this helps. Thanks to all
SKip
 
B

Bob Phillips

B1: =IF(A1>A2,A1-A2,"")
B2: =IF(A1<A2,A2-A1,"")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Top