If Amount Question

[Guest]

Hi there

I need a formula if column C2 has an amount 600 or above return a result of 1
If there's no number leave it blank or if the number is below 600 leave it
blank as well

Thanks!

 

[T. Valko]

Try this:

=IF(AND(ISNUMBER(C2),C2>=600),1,"")

 

[David Biddulph]

Do you need the ISNUMBER test, Biff? Can it be >=600 without there being a
number in the cell?

 

[David Biddulph]

I've now realised that a cell with text representing a number greater than
or equal to 600 will satisfy the >=test, but not the ISNUMBER test. So your
formula draws that distinction.

 

[T. Valko]

Also, consider the possibility that C2 contains a formula that might return
a blank.