Thread: formula help - subtracting numbers in two colums but using a specificnumber if one column is greater than another
View Single Post
  #2   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 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

Reply With QuoteReply With Quote