Forum Discussion
Help with table, calculating cost
Hello I'm trying to work out how to make a table populate a cost for me. I want to be able to select the item for x amount of days and my spreadsheet tell me how much that will cost. I have the d...
=ROUND((A1 * B1 * C1) * (1 - D1/100), 2)
Here's a breakdown of the formula:
A1: Day rate
B1: Quantity
C1: Number of days
D1: Discount percentageage in D1.
Here's a breakdown of the formula:
A1: Day rate
B1: Quantity
C1: Number of days
D1: Discount percentageage in D1.
This is wonderful thankyou, though i've just noticed that i have a 7 day rate, not a day rate and thats whats throwing my total off.
Replace C1 with ROUNDUP(C1/7, 0) in the proposed formula
