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(A1gt;0,A1,quot;quot;)
In Cell C1...
=if(A1lt;0,-A1,quot;quot;)
HTH,
--
Gary Brown
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;s.m.hardinquot; wrote:
gt; Is there a way I that excel can know when a number is positive or negative
gt; and put the correct sum in the correct coulumn?
SUM doesn't need to know, it adds up correctly regardless.
--
HTH
RP
(remove nothere from the email address if mailing direct)quot;s.m.hardinquot; gt; wrote in message
...
gt; Is there a way I that excel can know when a number is positive or negative
gt; and put the correct sum in the correct coulumn?
quot;s.m.hardinquot; wrote:
gt; Is there a way I that excel can know when a number is positive or negative
gt; 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?
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?
quot;Gary L Brownquot; wrote:
gt; Assumptions:
gt; Cell A1 has a number
gt; Cell B1 has Debits
gt; Cell C1 has Credits
gt;
gt; Formulas:
gt; In Cell B1...
gt; =if(A1gt;0,A1,quot;quot;)
gt; In Cell C1...
gt; =if(A1lt;0,-A1,quot;quot;)
gt;
gt; HTH,
gt; --
gt; Gary Brown
gt;
gt; If this post was helpful, please click the ''Yes'' button next to ''Was this
gt; Post Helpfull to you?''.
gt;
gt;
gt; quot;s.m.hardinquot; wrote:
gt;
gt; gt; Is there a way I that excel can know when a number is positive or negative
gt; gt; and put the correct sum in the correct coulumn?
C1: =SUM(IF(A1:B1gt;0,A1:B1))
D1: =SUM(IF(A1:B1lt;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)quot;s.m.hardinquot; gt; wrote in message
...
gt;
gt;
gt; quot;s.m.hardinquot; wrote:
gt;
gt; gt; Is there a way I that excel can know when a number is positive or
negative
gt; gt; 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?
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(A1gt;0,A1,quot;quot;)
In Cell C1...
=if(A1lt;0,-A1,quot;quot;)
HTH,
--
Gary Brown
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;s.m.hardinquot; wrote:
gt; Is there a way I that excel can know when a number is positive or negative
gt; and put the correct sum in the correct coulumn?
SUM doesn't need to know, it adds up correctly regardless.
--
HTH
RP
(remove nothere from the email address if mailing direct)quot;s.m.hardinquot; gt; wrote in message
...
gt; Is there a way I that excel can know when a number is positive or negative
gt; and put the correct sum in the correct coulumn?
quot;s.m.hardinquot; wrote:
gt; Is there a way I that excel can know when a number is positive or negative
gt; 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?
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?
quot;Gary L Brownquot; wrote:
gt; Assumptions:
gt; Cell A1 has a number
gt; Cell B1 has Debits
gt; Cell C1 has Credits
gt;
gt; Formulas:
gt; In Cell B1...
gt; =if(A1gt;0,A1,quot;quot;)
gt; In Cell C1...
gt; =if(A1lt;0,-A1,quot;quot;)
gt;
gt; HTH,
gt; --
gt; Gary Brown
gt;
gt; If this post was helpful, please click the ''Yes'' button next to ''Was this
gt; Post Helpfull to you?''.
gt;
gt;
gt; quot;s.m.hardinquot; wrote:
gt;
gt; gt; Is there a way I that excel can know when a number is positive or negative
gt; gt; and put the correct sum in the correct coulumn?
C1: =SUM(IF(A1:B1gt;0,A1:B1))
D1: =SUM(IF(A1:B1lt;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)quot;s.m.hardinquot; gt; wrote in message
...
gt;
gt;
gt; quot;s.m.hardinquot; wrote:
gt;
gt; gt; Is there a way I that excel can know when a number is positive or
negative
gt; gt; 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?
