Thread: If, Then Values
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default If, Then Values
=MAX(A2-A1,0)


"bassplayerbg" wrote:

I am trying to find a formula that will return a value in another cell if the
number is greater than the selected cell. Example:

cell A1 is 100
cell A2 is 150

I want the difference of 50 to be returned in cell A3 only if its a greater
number.

Hope it makes sence.

Thanks
CMS
Reply With QuoteReply With Quote