Finding the difference
You can do it this way:
=MAX(A1-60,0)
Hope this helps.
Pete
On Aug 1, 2:42*pm, 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!
|