Forum Discussion

Deleted's avatar
Deleted
Dec 09, 2021
Solved

I NEED HELP! EXAM TOMORROW

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%...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Dec 09, 2021

    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.

     

Deleted's avatar
Deleted
Dec 09, 2021
I tried doing this and only values showed up for the cells that had 8 and 24 in them. I think the problem is that these are ranges of numbers
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Dec 09, 2021

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?

  • Deleted's avatar
    Deleted
    Dec 09, 2021
    https://1drv.ms/x/s!AnjmDW-OfCa5gRlfNwa65cPXFIOZ?e=ZOWFzc