Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 5th 10, 12:19 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 3
Default Add a set number to a random entered number

I have to start a vehicle service record and am trying to add the 6000 mile
service interval to the mileage at service number.
EG.
A B C D
1 6000 12000

2 12125 18125

3 18200 24200 etc

A is the mileage at service and C is the next service due.I am trying to do
this without having a cell with a line of 6000 in it and the formula eg
=SUM(A1:B1) in the C cell.Is this possable?Hope some one can help.

  #2   Report Post  
Old January 5th 10, 12:59 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 4
Default Add a set number to a random entered number

Hi

=A1+6000

HTH. Best wishes Harald

"Cyclops" skrev i melding
...
I have to start a vehicle service record and am trying to add the 6000 mile
service interval to the mileage at service number.
EG.
A B C D
1 6000 12000

2 12125 18125

3 18200 24200 etc

A is the mileage at service and C is the next service due.I am trying to
do
this without having a cell with a line of 6000 in it and the formula eg
=SUM(A1:B1) in the C cell.Is this possable?Hope some one can help.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number entered isn't number recorded in cell. BubbaGee Excel Discussion (Misc queries) 4 September 11th 07 09:38 PM
Addding a Random number to a fixed number..... Dermot Excel Discussion (Misc queries) 6 August 20th 06 12:17 PM
How can I match a random number with closest number from sequence? Matt Excel Worksheet Functions 4 August 3rd 06 01:22 AM
same number appears in a random number generator Carmel Excel Worksheet Functions 4 May 28th 06 12:22 AM
Generating (in a random order)each number once from a given number Neil Goldwasser Excel Worksheet Functions 2 December 2nd 05 11:27 PM


All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017