Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Im creating a database for my school house and before i convert over to
Access..Im trying to figure out some ways to calculate some numbers. For example, my hardest thing yet, if someone was to run an 18min:00sec 3mile run...he'll get a max score of 100. But if he ran it in 20min:34sec he'll get a score of 84. Being the longest run of 28min:00sec (failing). How do i create a formula to calculate the mins and sec to result in the point score. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
apply cell names to formulas in multiple worksheets | Excel Worksheet Functions | |||
Using a single cell in multiple formulas | Excel Worksheet Functions | |||
How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
Multiple formulas including INDIRECT | Excel Worksheet Functions |