Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separte columns for neg/pos values
I need to find a formula which will take the difference between two numbers
and put them in one column if it is a negative value and in another column if it is a positive value. Help Ginger |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separte columns for neg/pos values
You'll need two formulas. Let's assume your numbers are in cells A1 and B1.
In C1, we'll show the difference if positive. In D1, we'll show the difference if negative. In C1: =IF(A1-B1=0,A1-B1,"") In D1: =IF(A1-B1<0,A1-B1,"") HTH, Elkar "Ginger" wrote: I need to find a formula which will take the difference between two numbers and put them in one column if it is a negative value and in another column if it is a positive value. Help Ginger |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separte columns for neg/pos values
Hi!
Suppose you want to subtract column B from column A. B1-A1, B2-A2, B3-A3, etc. Enter this formula in D1 for the positive results: =IF(B1-A1=0,B1-A1,"") Enter this formula in E1 for the negative results: =IF(B1-A1=0,"",B1-A1) Select both D1 and E1 and copy down as needed. Biff "Ginger" wrote in message ... I need to find a formula which will take the difference between two numbers and put them in one column if it is a negative value and in another column if it is a positive value. Help Ginger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distribute values evenly in two columns | Excel Discussion (Misc queries) | |||
Looking-up Columns w/calc'd Values ONLY to Calculate Average | Excel Worksheet Functions | |||
Multipying columns that contail null values | Excel Discussion (Misc queries) | |||
Totalling values across columns | Excel Worksheet Functions | |||
Creating a chart with values from two columns | Charts and Charting in Excel |