Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Master invoice number | Excel Worksheet Functions | |||
Adding a version number to a document | Excel Discussion (Misc queries) | |||
adding a zero in front of number | Excel Discussion (Misc queries) | |||
How do I sum a number of columns and ignore the minimum value? | Excel Discussion (Misc queries) |