Thread: greater than..
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default greater than..
=IF(A1<600,0,A1-600)
or
=MAX(A1-600,0)

Strictly, you haven't specified what you want if A1 is *equal* to 600, but
I've guessed.

Since A1-600 equals 0 when A1 equals 0, would it have been possible for you
to have guessed wrong?<g

Rick

Reply With QuoteReply With Quote