Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |