| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help - subtracting numbers in two colums but using a specificnumber if one column is greater than another
I am working on a spreadsheet and need help developiung a formula (my
excel knolwedge is very basic).... In y2, I want a formula that subtracts w2 from x2 but if x2 is w2 I want y2 to reflect the number in w2. Can anyone help me with that? I will be eternally grateful! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula help - subtracting numbers in two colums but using aspecific number if one column is greater than another
I THINK I JUST FIGURED IT OUT!! THE FORMULA I ARRIVED AT IS
=IF(X2W2, W2,SUM(W2,-X2)) DOES THIS SEEM CORRECT? I USED CSE WHEN I ENTERED THE FORMULA |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula help - subtracting numbers in two colums but using a specific number if one column is greater than another
You don't need the SUM function.
You have changed your parameters from your original posting. "subtracts w2 from x2" was your original. Here you are subtracting X2 from W2 You do not need CSE See my earlier reply. Gord On Mon, 4 Jan 2010 14:26:06 -0800 (PST), Michelle wrote: I THINK I JUST FIGURED IT OUT!! THE FORMULA I ARRIVED AT IS =IF(X2W2, W2,SUM(W2,-X2)) DOES THIS SEEM CORRECT? I USED CSE WHEN I ENTERED THE FORMULA |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula help - subtracting numbers in two colums but using a specific number if one column is greater than another
You sure that's what you want?
You will always get a zero or negative number in Y2 if X2<=W2 =IF(X2W2,W2,X2-W2) Gord Dibben MS Excel MVP On Mon, 4 Jan 2010 14:06:41 -0800 (PST), Michelle wrote: I am working on a spreadsheet and need help developiung a formula (my excel knolwedge is very basic).... In y2, I want a formula that subtracts w2 from x2 but if x2 is w2 I want y2 to reflect the number in w2. Can anyone help me with that? I will be eternally grateful! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT | Excel Worksheet Functions | |||
| Find min() value greater than zero in column of numbers | New Users to Excel | |||
| Adding or subtracting numbers from a column | Excel Discussion (Misc queries) | |||
| How to average a column of numbers that are greater than 0? | Excel Worksheet Functions | |||
| formula of two numbers if greater than 500 | Excel Discussion (Misc queries) | |||
Hybrid Mode
