LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
LCpl Shaw
 
Posts: n/a
Default Multiple Formulas

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Formulas for counting multiple conditions OrdOff Excel Worksheet Functions 4 July 3rd 05 06:12 PM
apply cell names to formulas in multiple worksheets BBurrows Excel Worksheet Functions 4 July 1st 05 05:35 PM
Using a single cell in multiple formulas ebethcat Excel Worksheet Functions 1 May 26th 05 02:42 PM
How to create Multiple Conditional Formulas in a single cell? Maxfx Excel Discussion (Misc queries) 2 February 1st 05 02:26 PM
Multiple formulas including INDIRECT Gizmo Excel Worksheet Functions 4 December 21st 04 07:07 PM


All times are GMT +1. The time now is 12:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"