Thread: formula help - subtracting numbers in two colums but using a specificnumber if one column is greater than another
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote