formula for negative and positive numbers in different columns
"s.m.hardin" wrote:
Is there a way I that excel can know when a number is positive or negative
and put the correct sum in the correct coulumn? here is an example so you know what I 'm asking. a1 has a positive number and b1 has a negative number, but in c1 is were the positive answer goes and d1 is were the nagative answer goes. Is there a certian formula that can do all that?
|