Hello i am using excel 2010 and i am told to calculate the discount rate for the off peak rental price per day. For example using the peak and off peak per day values, the studio apartment rents for 75% of its peak rental rate. However you need to calculate and display the off peak discount rate which is 25%.. Cell c6 is peak and its 149.95 and off peak is e6 at 112.50 and number of units is in b6 at 6How to Calculate this percentage in excel?
to get 112.50 you must be rounding to the nearest half dollar, since 25% of 149.95 is 112.46.
with C6 being the peak rate of 149.95, I put the discount rate in D6 as 25% and in E6, this formula:
=MROUND(C6-(C6*D6), 0.5)
or
=MROUND(C6*(1-D6), 0.5)
Both formulas will round the actual total of $112.46 to the nearest multiple of .5, which results in $112.50.
# of units doesn't come into play in the percentage formula. I'm guessing you use that in other formulas to determine totals, etc.... such as 6 units @ $149.95 each gives $899.70, while the discount rate total for 6 units is $675.00
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment