4 IF Statements within Excel

[mobyzone]

Hi all,

I'm wanting to do an IF statement but include 4 statements in the same formula.

IF E8 is less than 50000 then return 1, if its between 50000 and 100000 then return 2, if its between 100000-250000 then return 3, otherwise greater than 250000 return 4.

Any ideas?

Thanks

 

[T. Valko]

Hi all,

I'm wanting to do an IF statement but include 4 statements in the same formula.

IF E8 is less than 50000 then return 1, if its between 50000 and 100000 then return 2, if its between 100000-250000 then return 3, otherwise greater than 250000 return 4.

Any ideas?

Thanks

Your levels are not well defined!

You have overlaps at 100000 and 250000.

See if this is what you had in mind:

=IF(COUNT(E8),MATCH(E8,{0,50000,100000,250000}),"")

 

[Robert Mika]

=if(e8="","",if(e8<50000,1,if(and(e8>=50000,e8<100000),2,if(and(e8>=100000,e8<2500000),3,4))))

 

[mobyzone]

=if(e8="","",if(e8<50000,1,if(and(e8>=50000,e8<100000),2,if(and(e8>=100000,e8<2500000),3,4))))

Thats excellent thanks so much!

 

[T. Valko]

=if(e8="","",if(e8<50000,1,if(and(e8>=50000,e8<100000),2,if(and(e8>=100000,e8<2500000),3,4))))

No need for the AND functions:

=IF(E8="","",IF(E8<50000,1,IF(E8<100000,2,IF(E8<2500000,3,4))))

See my comment about the levels not being clearly defined.

 

[mobyzone]

No need for the AND functions:

=IF(E8="","",IF(E8<50000,1,IF(E8<100000,2,IF(E8<2500000,3,4))))

See my comment about the levels not being clearly defined.

Thanks for that,

1 more,

If F8 has any value in it return 1, if G8 has any value return 2, if F8 and G8 both have a value then return 3?

Thanks

 

[T. Valko]

Thanks for that,

1 more,

If F8 has any value in it return 1, if G8 has any value return 2, if F8 and G8 both have a value then return 3?

Thanks

Try this..

=IF(COUNT(F8:G8)=2,3,IF(COUNT(F8),1,IF(COUNT(G8),2,"")))