| 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 |
| 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 | |||
Threaded Mode
