Need help with a formula

[David]

I'm trying to create a formula to calculate how much profit one would make
if it only rents 85% of its 40 stations for $5.00 an hour when the company
is open for a max. 83 hours per week.

B2 = Total number of stations (40) (cell is formatted as a number)
C2 = $/hour ($5.00) (cell is formatted as currency w/ 2 decimal places)
D2 = % Utilization (85%) (cell is formatted as a percentage with no decimal
places)
E2 = Gross Profit (formatted at currency w/ 2 decimal places)
Number of hours per week = 83 (will not change)

I have got a formula in and it works for 100% but as soon as I change it to,
say 50%, the gross profit will double not reduce by half.
EX. =SUM(((B3/D3)*C3)*83)
with the above numbers at 100% the result of this formula is $16,600.00
(this is the correct amount)
If I change it to 50% the result is $33,200.00 (which is double not half.
The correct amount should be $8,300.00)

Something is wrong... Any help would be appreciated.
David

 

[Max]

Try instead, for "Gross Profit" column,
in E2: =B2*D2*C2*83

 

[David]

That did it!
Thanks for the help

Try instead, for "Gross Profit" column,
in E2: =B2*D2*C2*83

 

[Max]

Pleasure' David !