Function help needed please

  • Thread starter Thread starter Ian Harris
  • Start date Start date
I

Ian Harris

Hi
How can I do the following I have five columns
Col 1 Mileage counter start
Col 2 Mileage counter end
Col 3 Mileage done (total from start to end column )
Col 4 Mileage Purpose (this will be entered as either Business Or
Personal)
Col 5 Mileage cost
I need to work cost of mileage done at a rate £0.12p per mile only if it has
business in third column this needs to be done on daily basis whilst still
keeping a record of all mileage totals be it business or personal

Hope this explains my problem ok
Many thanks
Ian
 
Hi Ian
one way (I thin the business purpose is in column D):
=SUMIF($D$2:$D$999;"Business";$C$2:$C$999)*0,12

Of course you can put the rate per mile in a dedicated cell and replace
*0,12 with a reference to this cell:
=SUMIF($D$2:$D$999;"Business";$C$2:$C$999)*$G$1
If G1 stores the rate

HTH
Frank
 
Ian,

In F1

=IF(D1="Business",C1*E1,"")

and just total them

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top