IF...assistance

[350GTR]

Hey Gang!

Can anyone assit me with the following scenario:

- A1 has a drop-down list (Juniors,Seniors)
- I would like to have L10 to automatically select the appropraite formula when either 'Juniors' or 'Seniors' is selected in A1

Below are their respective formulas:
=IF(L8<12000,"30%",IF(L8<20000,"40%",IF(L8<30000,"50%",IF(L8<40000,"55%",IF(L8<50000,"60%",IF(L8>49999.99,"65%","")))))) formula for Juniors based on value on L8

=IF(L8<12000,"40%",IF(L8<30000,"50%",IF(L8<40000,"55%",IF(L8<50000,"60%",IF(L8>49999.99,"65%","")))))) formulas for seniros based on value for L8

Any suggestions are greatly appreciated!

 

[Brian from Maui]

See the Help files for VLOOKUP.

 

[350GTR]

Thanks for that advise but I searched with no avail thus why the post...sorry

 

[Brian from Maui]

Thanks for that advise but I searched with no avail thus why the post...sorry

You'll probably have to change the table,

Book2
	A	B	C	D
1	1	30%	11999	30%
2	12001	40%	19000	40%
3	20001	50%	29999	50%
4	30001	55%	29999	50%
5	40001	60%	45000	60%
6	50000	65%	50000	65%
Sheet1