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!
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!