Forum Discussion
Zeusadmin
Jan 11, 2024Copper Contributor
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...
Zeusadmin
Jan 11, 2024Copper Contributor
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.
HansVogelaar
Jan 11, 2024MVP
Replace C1 with ROUNDUP(C1/7, 0) in the proposed formula