If Amount Question
 

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!

If Amount Question
 

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!

If Amount Question
 

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!

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!

If Amount Question
 

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

--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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!