Finding the difference
On Fri, 1 Aug 2008 06:42:00 -0700, Heather
wrote:
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!
Try this formula:
=IF(A1<60,0,A1-60)
Hope this helps / Lars-Åke
|