Remember Me?

#1
January 16th 06, 10:08 PM posted to microsoft.public.excel.newusers
 Elau Posts: n/a
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
January 16th 06, 10:24 PM posted to microsoft.public.excel.newusers
 gls858 Posts: n/a
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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Wes Lucas Excel Worksheet Functions 3 December 12th 05 01:37 PM Cathy Landry Excel Worksheet Functions 5 December 7th 05 08:30 PM michaelas Excel Worksheet Functions 3 August 24th 05 04:28 PM RICHARD Excel Worksheet Functions 1 March 15th 05 05:49 PM RICHARD Excel Discussion (Misc queries) 0 March 1st 05 01:53 PM

All times are GMT +1. The time now is 10:19 AM.