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

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

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

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

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

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

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

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