Calculating for personal car mileage?

Elau · January 16th, 2006, 10:08 PM posted to microsoft.public.excel.newusers

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!!!

gls858 · January 16th, 2006, 10:24 PM posted to microsoft.public.excel.newusers

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculating the right formula	michaelas	Worksheet Functions	3	August 24th, 2005 04:28 PM
Using Max function to show current mileage	MitziUK	New Users	5	June 3rd, 2005 01:46 PM
Calculating one record/Form	Tiffany	Using Forms	2	May 27th, 2005 04:06 AM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets)	RICHARD	Worksheet Functions	1	March 15th, 2005 05:49 PM
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS!	RICHARD	General Discussion	0	March 1st, 2005 01:53 PM