=IF(F6<>" ",F6-G6," ") I have 3 columns on the mileage report. Miles, Less Miles and total miles. Miles is in column F6, less miles G6. The total miles would be if F6 is greater or less than, I would get a total in total miles.
=IF(H6<>" ",+H6*0.31," ") This formula contains that rate we would reimburse the mileage at. If total miles H6, is less than or greater than, then it would multiply at a rate of .310.