neater!

KL


"Bob Phillips" wrote in message
...
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