Multiple "IF" statement

[Wadecb7]

Good Morning

I need to do a multiple "IF" statement and have no clue how to do it.

Please help

E.g:

3500 up = 1
1000 - 3499 = 2
350 - 999 = 3
100 - 349 = 4
0 - 99 = 5

Thanks

 

[Trebor76]

Hi there,

Though you could use a nested IF statement, try this (just change the cell reference to suit):

=IF(ISNUMBER(A31)=TRUE,LOOKUP(A31,{0,100,350,1000,3500},{5,4,3,2,1}),0)

Regards,

Robert

 

[Peter_SSs]

Or, similar idea to Robert but make the 'lookup table' in your sheet rather than in the formula itself. Formula in B2 is copied down.

Excel Workbook
	A	B	C	D	E
1
2	286	4		0	5
3	4216	1		100	4
4	21	5		350	3
5				1000	2
6				3500	1
7
Lookup Table