try
=if(a1=600,a1-600,0)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eclaires" wrote in message
...
Please would someone help me.. I am trying to enter a formula to return a
value, in another cell, if a cell is greater than or less than a specific
value.

eg: if the value in cell a1 is less than 600 return value of 0 in cell a2,
or if greater than 600 caluculate the difference between a1 and 600 and
return the result in a2.

Many thanks

Eclaires