I am not really good with Excel, I am just learning, so if anyone can help me that would be great. What I want to be able to do is a have a formula that will sum two cells (that I can do) but if the sum is a negative I want it to show as a Zero instead of a negative number (figured that out with an IF formula), but if the sum is greater than 0 I want it to show as the actual sum of the two cells(this I don't know how to do). Is there a way to do this?
2007-08-17 06:48:09 · 2 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
Say you have the following data
A1=100 B1=75
A2=10 B2=-25 negative
Now type in C1
=IF (A1+B1>0,A1+B1,0) You should get the answer 175
Now copy that formula to C2, then you should get the answer 0
(to copy the formula, select C1 & press Ctrl+C keys together
Then select C2 and press Enter)
2007-08-17 07:54:11 · answer #1 · answered by voyager 6 · 2⤊ 0⤋
If A1 + B1 >0, "A1+B1, 0
2007-08-17 13:57:04 · answer #2 · answered by Stareyes 5 · 0⤊ 0⤋