| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for negative and positive numbers in different columns
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula for negative and positive numbers in different columns
Assumptions:
Cell A1 has a number Cell B1 has Debits Cell C1 has Credits Formulas: In Cell B1... =if(A10,A1,"") In Cell C1... =if(A1<0,-A1,"") HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula for negative and positive numbers in different columns
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" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula for negative and positive numbers in different columns
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? "Gary L Brown" wrote: Assumptions: Cell A1 has a number Cell B1 has Debits Cell C1 has Credits Formulas: In Cell B1... =if(A10,A1,"") In Cell C1... =if(A1<0,-A1,"") HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula for negative and positive numbers in different columns
C1: =SUM(IF(A1:B10,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) "s.m.hardin" wrote in message ... "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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
| FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| how to build a formula to match numbers in 2 columns with the equ. | Excel Worksheet Functions | |||
Linear Mode
