View Single Post
  #2   Report Post  
Henry
 
Posts: n/a
Default


"Cinder" wrote in message
...
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