Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Functions & formulas
I am creating a form and the conditions are... a student is required to have
a minimum of 20 clinical hours. And for each additional 4 hours they receive 1 point up to 40 hours over the required minimum. For example for 24 hours they would receive 1 point and 60 hours they would receive 10 points. How do I write a formula to do this. Thanks R |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas and functions | Excel Discussion (Misc queries) | |||
Functions & Formulas | Excel Worksheet Functions | |||
functions/formulas | Excel Worksheet Functions | |||
Using formulas/functions | Excel Worksheet Functions | |||
functions/formulas | Excel Worksheet Functions |