20080714 1914 GMT-6
I'm working on another spread sheet for an indoor soccer club.
The club wants to send out to the teams a spreadsheet that has a certain number
of columns in it and they team fills out and email it back.
One of the columns is calculated by referencing another column and IF the column
is checked ( has a x in it) then perform this calculation:
$Cost / $Number_of_players + $service = $price_per_player
Column B2 is $Cost
$number_of_players is column B3 though B30 only
$service is column G3 through G30 only
And
$price_per_player is column H3 though H30
So basically, if there are say 15 people on the roster and only 4 have paid
the calculation would be:
(test values)
$500 / 4 + $5 = $130
And in the rows that are checked (the committed column) those rows would have
$130 showing that if only 4 players played, it would cost $130 each.
Its more complicated to explain it than it really is but what my question is,
I'm just looking for a pointer on how to do this? Heck, I could just create a
web page do to the calculation faster than I can explain it :) but that doesn't
help anyone.
Wade
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
