Help with IF function

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
 
C

Claus Busch

Hi Jooniper,

Am Wed, 22 Aug 2012 09:19:21 +0000 schrieb 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%=7
points and >95%=10 points.
I have tried to start this formula, but I am stuck. So any help would be
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")))))

try:
=VLOOKUP(B8,{0,0;0.9,5;0.94,7;0.95,10},2,1)
but watch your language specific seperators


Regards
Claus Busch
 
J

joeu2004

Jooniper said:
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%=7 points and >95%=10 points.
I have tried to start this formula, but I am stuck. [....]
=IF((B8<=90%),0),(IF(AND(B8>90%,B8<=94%),5),(IF(AND(B8>94%,
B8=95%),7),((IF( B8>95%, 10, "no")))))

Your ranges are ambiguous. If 94%, do you want to award 5 or 7 points?

=IF(B8<90%,0,IF(B8<94%,5,IF(B8<=95%,7,10)))

Caveat: A cell might appear to be 94%, but it is actually less (as little
as 93.5%) due to formatting. I presume that B8 is rounded to 2 decimal
places. If not, you might want to replace B8 with ROUND(B8,2) in the
formula above. Or you might not. It depends on your intent. Do you want
93.9999999999999% to be awarded 5 or 7 points, assuming 94% is awarded 7
points?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top