View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Finding the difference

=if(a160,a1-60,0)*whatever

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Heather" wrote in message
...
Please help me with the following problem.

If cell A1 = 60 or less than equals 0.
But if cell A1 = more than 60, say 80, than I would like to get the
difference so I can multiply it by a $$ amount.

Thank you for any help!