Function help needed please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ian Harris - 20 Jan 2004 15:10 GMT

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

Reply to this Message

Frank Kabel - 20 Jan 2004 15:17 GMT

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

> Hi
> How can I do the following I have five columns
[quoted text clipped - 12 lines]
> Many thanks
> Ian

Reply to this Message

Bob Phillips - 20 Jan 2004 15:17 GMT

Ian,

In F1

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

and just total them

Signature

HTH

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

> Hi
> How can I do the following I have five columns
[quoted text clipped - 11 lines]
> Many thanks
> Ian

Reply to this Message

Ian Harris - 21 Jan 2004 06:39 GMT

Many thanks for you help guys

> Hi
> How can I do the following I have five columns
[quoted text clipped - 11 lines]
> Many thanks
> Ian

Reply to this Message