IF
 

=IF(G950<60000,1)+IF(G95060001<149999,2)+IF(G950 150000,3) this formula is
wrong and not sure what i need to do
I have a column with numbers ranging from 0-20000 and i need <60000 to pick
up 1, and between 60001-149999 to pick 2 and then 150000 to pick up 3
can anyone help
thank you

IF
 

Try it like this, without any gaps:

=IF(G950="","",IF(G950<60000,1,IF(AND(G950=60000, G950<150000),2,3)))

Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tigger07" <u38151@uwe wrote in message news:7985b5f4fdff8@uwe...
=IF(G950<60000,1)+IF(G95060001<149999,2)+IF(G950 150000,3) this formula
is
wrong and not sure what i need to do
I have a column with numbers ranging from 0-20000 and i need <60000 to
pick
up 1, and between 60001-149999 to pick 2 and then 150000 to pick up 3
can anyone help
thank you

IF
 

Max wrote:
Try it like this, without any gaps:

=IF(G950="","",IF(G950<60000,1,IF(AND(G950=60000 ,G950<150000),2,3)))

Adapt to suit
=IF(G950<60000,1)+IF(G95060001<149999,2)+IF(G950 150000,3) this formula
is
[quoted text clipped - 4 lines]
can anyone help
thank you
brilliant - many thanks

IF
 

welcome, glad it helped
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tigger07" <u38151@uwe wrote
brilliant - many thanks

IF
 

But you don't need the AND(G950=60000,... as you've already dealt with the
G950<60000 case.

=IF(G950="","",IF(G950<60000,1,IF(G950<150000),2,3 ))
[... and additionally the OP may need to think about the boundaries, and
whether < might be <= as there were gaps in the original spec.]
--
David Biddulph

"Max" wrote in message
...
Try it like this, without any gaps:

=IF(G950="","",IF(G950<60000,1,IF(AND(G950=60000, G950<150000),2,3)))

Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tigger07" <u38151@uwe wrote in message news:7985b5f4fdff8@uwe...
=IF(G950<60000,1)+IF(G95060001<149999,2)+IF(G950 150000,3) this formula
is
wrong and not sure what i need to do
I have a column with numbers ranging from 0-20000 and i need <60000 to
pick
up 1, and between 60001-149999 to pick 2 and then 150000 to pick up 3
can anyone help
thank you