Forum Discussion
Solved
Formulas and Functions
Hello, I was hoping someone could help me. I am having trouble attempting to create a formula in my excel spreadsheet. I would like all the cells in one column to automatically calculate ...
I pasted your example into a worksheet, then added formulas based on the one in my previous reply.
Sheet 1 is your example, Sheet2 has the formulas. The results appear to be the same.
This problem seems to be changing by the day? In addition it is not obvious to me what rate should correspond to 100.5 km. Anyway, to extend my former solution attempt
= LET(
rates, CEILING.MATH(50 + distance, 50) / 100,
rndUp, CEILING.MATH(distance, 10),
HSTACK(rates, rndUp, rates*rndUp)
)
- Thanks Peter, My issue has been solved. Appreciate the assistance.
