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(B890%,B8<=94%),5),(IF(AN D(B894%,
B8=95%),7),((IF( B895%, 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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2