Dec 09 2021 01:29 PM
Dec 09 2021 01:29 PM
I have a question that i need help for an exam tomorrow. I have list of numbers that show the number of games played by NBA players. The questions says that if you play less than 8 games you get a 2% bonus, if you play 8-16 games you get a bonus of 3% and if you play 17-24 games you get a bonus of 4%. I have a list of values (8,13,17,22,28,29). The question wants me to make a dynamic formula that shows what bonus each player will get based on the games they have played.
Dec 09 2021 01:37 PM
Solution@Deleted
=IF(B2<8,2,IF(AND(B2>=8,B2<=16),3,IF(AND(B2>=17,B2<=24),4,"")))
This can be done with a nested IF formula for example.
Dec 09 2021 01:42 PM
Dec 09 2021 01:53 PM
@Deleted
I can't imagine what the ranges of numbers look like. Are these ranges in single cells like "0 - 7" and "8 - 16" and "17 - 24".
Can you attach a file that shows the data you want to analyse?
Dec 09 2021 01:57 PM
Dec 09 2021 02:01 PM
Dec 09 2021 02:03 PM
Dec 09 2021 02:20 PM
Dec 09 2021 01:37 PM
Solution@Deleted
=IF(B2<8,2,IF(AND(B2>=8,B2<=16),3,IF(AND(B2>=17,B2<=24),4,"")))
This can be done with a nested IF formula for example.