Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with IF function
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"))))) All help greatly received |
#2
|
|||
|
|||
Quote:
=IF(AND(B8=0%,B8<90%),0,IF(AND(B8=90%,B8<=94%),5 ,IF(AND(B894%,B8<=95%),7,IF(B895%,10)))) |
#3
|
|||
|
|||
YES! That is absolutely fantastic. Thank you very much for your help
|
#4
|
|||
|
|||
Glad to help :)
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with IF function
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with IF function
"Jooniper" wrote:
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(B890%,B8<=94%),5),(IF(AN D(B894%, B8=95%),7),((IF( B895%, 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming |