Forum Discussion
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.
Hi Hans,
Unfortunately that didn't work, please see below .
| From | To | Distance (Klm) | Rates | Round Up | Total |
| Wodonga | Wangaratta | 69.40 | $ 1.50 | 70.00 | $ 105.00 |
| Wodonga | Waldara | 73.20 | $ 1.50 | 80.00 | $ 120.00 |
| Wodonga | Glenrowan | 86.50 | $ 1.50 | 90.00 | $ 135.00 |
| Wodonga | Yarrawonga | 90.90 | $ 1.50 | 100.00 | $ 150.00 |
| Wodonga | Benalla | 110.30 | $ 2.00 | 120.00 | $ 240.00 |
| Wodonga | Warrenbayne | 129.60 | $ 2.00 | 130.00 | $ 260.00 |
| Wodonga | Wagga | 134.10 | $ 2.00 | 140.00 | $ 280.00 |
| Wodonga | Gobbagombalin | 137.00 | $ 2.00 | 140.00 | $ 280.00 |
| Wodonga | Coolamon | 162.90 | $ 2.50 | 170.00 | $ 425.00 |
| Wodonga | Mansfield | 171.90 | $ 2.50 | 180.00 | $ 450.00 |
| Wodonga | Mulwala | 93.80 | $ 1.50 | 100.00 | $ 150.00 |
I need the rate to increase as per the round up total eg: 50.00 - 100.00 = $1.50, 101.00 - 150.00 = $2.00 ect...
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.
- Thank Hans, this formula has done the job. Much appreciated.
