| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF
welcome, glad it helped
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Tigger07" <u38151@uwe wrote brilliant - many thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
