Hey,

Sorry I didn't realize that short formula did everything I asked for! Thank
you very much for your help.. Disregard the other replies asking for more
help!

PK

"Bob Phillips" wrote:

or MAX(B20-7,5,0)

--
HTH

Bob Phillips

"KL" wrote in message
...
Hi PK,

Try typing the following formula in [B21]:

=(B20-7.50)*(B20-7.5)

or

=IF(B20-7.50,B20-7.5,0)

Regards,
KL



"PK" wrote in message
...
Hi,

I need to compare a value in a cell and see if it is higher than 7.5.
If
it
is higher than 7.5 I want to subract 7.5 from it and move the result
into
another cell. For instance. If B20 7.5 Subract 7.5 from B20 and Move
to
B21. How can I do that easily? I was trying to use the IF function but
cannot find the correct formatting to get it to move the value to the
B21
cell.

Thanks,

PK