|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 4th, 2010, 10:06 PM
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
January 4th, 2010, 10:26 PM
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
January 4th, 2010, 11:04 PM
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!
|
|
#4
January 4th, 2010, 11:43 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
