Finding the difference
 

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!

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!

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

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!

Finding the difference
 

Heather

Maybe

=IF(A1<=60,"",A1-60)

Mike

"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!