J
Jooniper
I am trying to award points for performance using an IF function.
So, if they score less than 90%, 0 points, 90-94%=5 points, 94-95%=
points and >95%=10 points.
I have tried to start this formula, but I am stuck. So any help would b
great!
Here is whaty I wrote so far:
=IF((B8<=90%),0),(IF(AND(B8>90%,B8<=94%),5),(IF(AND(B8>94%
B8=95%),7),((IF( B8>95%, 10, "no")))))
All help greatly receive
So, if they score less than 90%, 0 points, 90-94%=5 points, 94-95%=
points and >95%=10 points.
I have tried to start this formula, but I am stuck. So any help would b
great!
Here is whaty I wrote so far:
=IF((B8<=90%),0),(IF(AND(B8>90%,B8<=94%),5),(IF(AND(B8>94%
B8=95%),7),((IF( B8>95%, 10, "no")))))
All help greatly receive