| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating for personal car mileage?
I want to create a formula that will calculate the amount of dollar due
employee if he uses his personal car for business purposes. I cannot figure out how to avoid to overwrite the formula I created to perform that function. For example, my formula is "=A1*0.485", but the formula is over written every time I enter 10 (miles) in A1. How do I solve this problem? Please help!!! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculating for personal car mileage?
Elau wrote:
I want to create a formula that will calculate the amount of dollar due employee if he uses his personal car for business purposes. I cannot figure out how to avoid to overwrite the formula I created to perform that function. For example, my formula is "=A1*0.485", but the formula is over written every time I enter 10 (miles) in A1. How do I solve this problem? Please help!!! In A1 put your miles. Put the formula in A2. gls858 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mileage calculator in EXCEL | Excel Worksheet Functions | |||
| Mileage Calculation | Excel Worksheet Functions | |||
| Calculating the right formula | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
Linear Mode
