Winding up the Mileage spreadsheet part 1

Hi People

Your  spreadsheet is now taking shape, enter the two remaining formulae as shown below, to make sure that when you copy the formulae (by the way formula is singular i.e  1 formula  2 or more are formulae) down the appropriate column (from row 3 to row 20).

For column G  we put

=if(E3="";"";E3/F3)
And using the little black box method to copy the formula to cell G3 to G20

For column H we put

=if(D3="","",F3/D3)
Again copy the formula to cells H3 to H20

There is one thing which we can do, to make things a little easier for you.  When you put in your mileage, from the start mileage you need to find out what the second mileage is and then subtract the start mileage from the second mileage.

This might be easier to explain with an example.

You decide to find out how many miles you do between filling up at the fuel station.

What you need is a full tank to start and the start mileage.  Now you cannot work out anything until you fill up with fuel again and get second mileage.  Once you have both, you can find out how many miles you have travelled and how many litres of fuel you have used.

So having put the start mileage into the spreadsheet, you cannot work out anything until the next fuel fill up and  mileage reading.  Therefore only cells A3 and B3 can have a value when you start using this spreadsheet.

On the next fill up you have your second mileage which can be used (by the spreadsheet) to calculate (yes I said calculate) the miles done.

To do this put in cell F4

=IF(B4<>"";IF(B4>B3;B4-B3;"value too small");"")

See if you can work out what is going on here (hints:  The '<>' is a 'not equal' sign , the '>' is a 'greater than' and look for 2 conditional if calculations one inside the other)
We will go through it together next time.

Until next time Thank You


Prometheus1618





We now have a FREE SPYWARE REPORT available, yours to keep and share if you wish. Fill in your details below and get yours now

eMail address:
First Name: