Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
dk
 
Posts: n/a
Default Adding a certain number until minimum is reached

I'm having problem figuring out how to do this.

If I have a number that is less that 20,000 in one cell, I want the next
cell to add to it in multiples of 5,000 until a miniumum 20,000 is reached.
I was wondering if anyone could help me with this.

Thanks

  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default Adding a certain number until minimum is reached

one way:

A2: =INT((19999-A1)/5000)*5000+A1

In article ,
"dk" wrote:

I'm having problem figuring out how to do this.

If I have a number that is less that 20,000 in one cell, I want the next
cell to add to it in multiples of 5,000 until a miniumum 20,000 is reached.
I was wondering if anyone could help me with this.

Thanks

  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Adding a certain number until minimum is reached

Try this:
A1: (some number less than 20,000)
Select from A1 down through A50
EditFillSeries
Series in: Columns
Step: 5000
Stop Value: 20000
Click [OK]

Does that help?

***********
Regards,
Ron


"dk" wrote:

I'm having problem figuring out how to do this.

If I have a number that is less that 20,000 in one cell, I want the next
cell to add to it in multiples of 5,000 until a miniumum 20,000 is reached.
I was wondering if anyone could help me with this.

Thanks

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Adding a certain number until minimum is reached

One way:

=IF(A1=20000,A1,A1+CEILING(20000-A1,5000))

(I think....)



dk wrote:

I'm having problem figuring out how to do this.

If I have a number that is less that 20,000 in one cell, I want the next
cell to add to it in multiples of 5,000 until a miniumum 20,000 is reached.
I was wondering if anyone could help me with this.

Thanks


--

Dave Peterson
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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Master invoice number Christopher M. Excel Worksheet Functions 0 July 24th 05 04:26 PM
Adding a version number to a document Tigsboy Excel Discussion (Misc queries) 2 July 21st 05 01:19 PM
adding a zero in front of number Pinky Excel Discussion (Misc queries) 3 April 7th 05 09:05 PM
How do I sum a number of columns and ignore the minimum value? Nicole Excel Discussion (Misc queries) 2 December 10th 04 02:03 AM


All times are GMT +1. The time now is 04:10 PM.

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

About Us

"It's about Microsoft Excel"