View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michelle Michelle is offline
external usenet poster
 
Posts: 11
Default 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!