| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help generating score from finishing position
I use a work sheet to track and calculate racing scores. I have an area were
I have to manually input the scores after I calculate them from the finishing position. What I would like to be able to do is just enter the finishing position in a cell and have it calculate the score in the same or adjoining cell. Im not sure what kind of formula or function to use for this. 1 = 90, 2 = 88, 3 = 86, 4 = 84 and so on to 43rd. Can anyone offer any help. Thanks -- Dan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help generating score from finishing position
Dan,
may be like this COL A COL B ROW 1 1 90 ROW 2 2 88 =92-2*A2 ROW 3 3 86 =92-2*A3 ROW 4 4 84 =92-2*A4 -- regards "Dan" wrote: I use a work sheet to track and calculate racing scores. I have an area were I have to manually input the scores after I calculate them from the finishing position. What I would like to be able to do is just enter the finishing position in a cell and have it calculate the score in the same or adjoining cell. Im not sure what kind of formula or function to use for this. 1 = 90, 2 = 88, 3 = 86, 4 = 84 and so on to 43rd. Can anyone offer any help. Thanks -- Dan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help generating score from finishing position
Assuming the trend is linear (-2 for each increment of 1):
A1 = finishing position (1 thru 43) Enter this formula in B1: =90-A1*2+2 -- Biff Microsoft Excel MVP "Dan" wrote in message ... I use a work sheet to track and calculate racing scores. I have an area were I have to manually input the scores after I calculate them from the finishing position. What I would like to be able to do is just enter the finishing position in a cell and have it calculate the score in the same or adjoining cell. I'm not sure what kind of formula or function to use for this. 1 = 90, 2 = 88, 3 = 86, 4 = 84 and so on to 43rd. Can anyone offer any help. Thanks -- Dan |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help generating score from finishing position
Or, taking a hint from Driller's post:
=92-A1*2 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Assuming the trend is linear (-2 for each increment of 1): A1 = finishing position (1 thru 43) Enter this formula in B1: =90-A1*2+2 -- Biff Microsoft Excel MVP "Dan" wrote in message ... I use a work sheet to track and calculate racing scores. I have an area were I have to manually input the scores after I calculate them from the finishing position. What I would like to be able to do is just enter the finishing position in a cell and have it calculate the score in the same or adjoining cell. I'm not sure what kind of formula or function to use for this. 1 = 90, 2 = 88, 3 = 86, 4 = 84 and so on to 43rd. Can anyone offer any help. Thanks -- Dan |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help generating score from finishing position
I'm not sure how to utilize this info into my work book.
-- Dan "driller" wrote: Dan, may be like this COL A COL B ROW 1 1 90 ROW 2 2 88 =92-2*A2 ROW 3 3 86 =92-2*A3 ROW 4 4 84 =92-2*A4 -- regards "Dan" wrote: I use a work sheet to track and calculate racing scores. I have an area were I have to manually input the scores after I calculate them from the finishing position. What I would like to be able to do is just enter the finishing position in a cell and have it calculate the score in the same or adjoining cell. Im not sure what kind of formula or function to use for this. 1 = 90, 2 = 88, 3 = 86, 4 = 84 and so on to 43rd. Can anyone offer any help. Thanks -- Dan |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help generating score from finishing position
Thank You All
-- Dan "T. Valko" wrote: Or, taking a hint from Driller's post: =92-A1*2 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Assuming the trend is linear (-2 for each increment of 1): A1 = finishing position (1 thru 43) Enter this formula in B1: =90-A1*2+2 -- Biff Microsoft Excel MVP "Dan" wrote in message ... I use a work sheet to track and calculate racing scores. I have an area were I have to manually input the scores after I calculate them from the finishing position. What I would like to be able to do is just enter the finishing position in a cell and have it calculate the score in the same or adjoining cell. I'm not sure what kind of formula or function to use for this. 1 = 90, 2 = 88, 3 = 86, 4 = 84 and so on to 43rd. Can anyone offer any help. Thanks -- Dan |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help generating score from finishing position
you're welcome n thanks for the feedback
"Dan" wrote: Thank You All -- Dan "T. Valko" wrote: Or, taking a hint from Driller's post: =92-A1*2 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Assuming the trend is linear (-2 for each increment of 1): A1 = finishing position (1 thru 43) Enter this formula in B1: =90-A1*2+2 -- Biff Microsoft Excel MVP "Dan" wrote in message ... I use a work sheet to track and calculate racing scores. I have an area were I have to manually input the scores after I calculate them from the finishing position. What I would like to be able to do is just enter the finishing position in a cell and have it calculate the score in the same or adjoining cell. I'm not sure what kind of formula or function to use for this. 1 = 90, 2 = 88, 3 = 86, 4 = 84 and so on to 43rd. Can anyone offer any help. Thanks -- Dan |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help generating score from finishing position
I'll second that!
-- Biff Microsoft Excel MVP "driller" wrote in message ... you're welcome n thanks for the feedback "Dan" wrote: Thank You All -- Dan "T. Valko" wrote: Or, taking a hint from Driller's post: =92-A1*2 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Assuming the trend is linear (-2 for each increment of 1): A1 = finishing position (1 thru 43) Enter this formula in B1: =90-A1*2+2 -- Biff Microsoft Excel MVP "Dan" wrote in message ... I use a work sheet to track and calculate racing scores. I have an area were I have to manually input the scores after I calculate them from the finishing position. What I would like to be able to do is just enter the finishing position in a cell and have it calculate the score in the same or adjoining cell. I'm not sure what kind of formula or function to use for this. 1 = 90, 2 = 88, 3 = 86, 4 = 84 and so on to 43rd. Can anyone offer any help. Thanks -- Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro not finishing due to loading workbook | Excel Discussion (Misc queries) | |||
| Make a sheet to enter score and score is copy to the proper cell.. | Excel Worksheet Functions | |||
| Finishing my Address Lookup | Excel Discussion (Misc queries) | |||
| Help finishing array formula! | Excel Worksheet Functions | |||
| Crashing when finishing charts | Excel Discussion (Misc queries) | |||
Linear Mode
