Thread: greater than..
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eclaires Eclaires is offline
external usenet poster
 
Posts: 10
Default greater than..

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