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...
I'm nearly there using =ROUND((C2/7 * D2 * E2) * (1 - F2/100), 2)
It gives me the correct figure before the discount comes off. I just cant get it to subtract the discount
See below. 0.51 - 72% is 0.14 and thats what I'm trying to get to
0.0238 8 19 72% 0.51
It gives me the correct figure before the discount comes off. I just cant get it to subtract the discount
See below. 0.51 - 72% is 0.14 and thats what I'm trying to get to
0.0238 8 19 72% 0.51
72% is equivalent to 72/100, so you shouldn't divide by 100:
=ROUND((C2/7 * D2 * E2) * (1 - F2), 2)
