ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Formula (https://www.excelbanter.com/excel-discussion-misc-queries/170464-excel-formula.html)

weejinit

Excel Formula
 
I need to set up a formula for mileage expense, with the formula multiplying
the reimbursement amount against mileage. How do I do this?

--
weejinit

FSt1

Excel Formula
 
hi
if is understand you correctly....
=(end milage-start milage)*reinbursement amount.
Put start milage in A1.
put end milage in B1.
Put reinbursement amout in C1.
=(B1-A1)*C1

Regards
FSt1

"weejinit" wrote:

I need to set up a formula for mileage expense, with the formula multiplying
the reimbursement amount against mileage. How do I do this?

--
weejinit



All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com