Hello,
I need to write a couple of multiple variable If formulas and I am struggling and wanted to see if the forum could help.
First if formula
If the reference cell is between 98% & 100% than you get 25 points
If the reference cell is between 97.9% & 95% than you get 10 points
If the reference cell is below 98% than you get 0 points
Second if formula
If the reference cell is between 0 & .19 than you get 50 points
If the reference cell is between .19 & .24 than you get 25 points
If the reference cell is .25 or higher than you get 0 points