mileage reimbursement formula

I have a spread sheet I was given to use for mileage reimbursement. They
have one colum where you enter the miles you've traveled, say 230 miles and
the formula is =IF(SUM(H18:H43)>0,SUM(H18:H43),"") the next column is
supposed to total the miles and I believe multiply by .36 per mile but the
formula is broke. What they have is: IF(SUM(I18:I43)*0.36)
can anyone help me figure out this formula?
Thanks,
Cinder

"Cinder" <[email protected]> wrote in message
news:[email protected]...
>I have a spread sheet I was given to use for mileage reimbursement. They
> have one colum where you enter the miles you've traveled, say 230 miles
> and
> the formula is =IF(SUM(H18:H43)>0,SUM(H18:H43),"")

Assuming this is in Cell H44

the next column is
> supposed to total the miles and I believe multiply by .36 per mile but the
> formula is broke. What they have is: IF(SUM(I18:I43)*0.36)

In Cell I44
=IF(H44>"",H44*0.36,"") should get you on the right road.


Henry

Probably something like...........

in cell I18

=If(H18>0,H18*0.36,"")
for each line entered

You can sum the results at the bottom of the sheet.

--
Greetings from New Zealand
Bill K

"Cinder" <[email protected]> wrote in message
news:[email protected]...
>I have a spread sheet I was given to use for mileage reimbursement. They
> have one colum where you enter the miles you've traveled, say 230 miles
> and
> the formula is =IF(SUM(H18:H43)>0,SUM(H18:H43),"") the next column is
> supposed to total the miles and I believe multiply by .36 per mile but the
> formula is broke. What they have is: IF(SUM(I18:I43)*0.36)
> can anyone help me figure out this formula?
> Thanks,
> Cinder
>