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.
