If Amount Question
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.
--
David Biddulph
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Do you need the ISNUMBER test, Biff? Can it be =600 without there being
a number in the cell?
--
David Biddulph
"T. Valko" wrote in message
...
Try this:
=IF(AND(ISNUMBER(C2),C2=600),1,"")
--
Biff
Microsoft Excel MVP
"Killer" wrote in message
...
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!
|