Uh oh. it gets even harder :P. New updated question:
I need it so that instead of just: =IF(D2>=45,IF(D2<=55,4,1),1), it would be something like:
If between 90-99, then display 45.
If between 80-89, then display 40.
If between 70-79, then display 35.