formula for negative and positive numbers in different columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Assumptions:
Cell A1 has a number
Cell B1 has Debits
Cell C1 has Credits

Formulas:
In Cell B1...
=if(A1>0,A1,"")
In Cell C1...
=if(A1<0,-A1,"")

HTH,
 
SUM doesn't need to know, it adds up correctly regardless.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
s.m.hardin said:
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?
Click to expand...
 
I will give a example of ehat I am talking about. a1 has a # and b1 has a #
c1 is were the positive answer goes and d1 is were the negative # goes. Is
there a formula that calculate that and put the +/- in the correct column?
 
C1: =SUM(IF(A1:B1>0,A1:B1))

D1: =SUM(IF(A1:B1<0,A1:B1))

which are both array formulae, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


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?
 
You must log in or register to reply here.

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

Red cell for negative numbers in Excel 1
How to change numbers from positive to negative. 2
Subtracting positive amts from negative and positive from positive 3
subtract a positive from a negative 7
Change positive to negative number 4
Why do I get correct answers to formula then #NAME for some no's 1
Counting consecutive negative value 7
Subtotaling minus negative numbers and posative numbers 3

Back
Top