Help with formula calculating target miles per day

[rah_92_xo]

Hi there,

Looking for help to populate cell B14 with a formula that works out the target miles per day per car required on a fleet of vehicles, to keep the overall cost per mile (cell B22) under £0.35.

Help appreciated!

 

[James006]

Hi,
Difficult to guess the formulas you are using in your sheet ...

But, most probably, you can find your solution in a matter of a couple of seconds with Goal Seek ...

see explanation : Goal Seek in Excel