# range calculation in terms of distance

#### SJ excel

##### New Member
guys i do need help for calculating range like no effect of terrain and anything. i need macro anything on my excel document to simultaneously calculate distance vs battery percentage .that is whenever it goes from 80% to 5% it will charge again means reset its counter and so on . my total range is 560 km on one charge that is if battery 10% it has completed 450 km.consider 505 km on one charge and reset counter .the distance is in km and accordingly percentage moves .for the first time the counter is 100%-10% only and other times its 80%-5%.hope u guys get it its same as km/litre.but this time percentage of car battery.please guys help me with it.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

Replies
0
Views
100
Replies
5
Views
148
Replies
26
Views
573
Replies
4
Views
150
Replies
14
Views
315

1,127,643
Messages
5,626,052
Members
416,158
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back