Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do Loop
I want to take a value and multiply it by a number 10
times in a row. I then need to save that 10th value. Then I want to continue on until I get to 20 and then save the 20th value. I want to also save the 30th, 40th, and 50th value. Can I do this with a Do Loop? How do I pull out the values I need? Thanks, Laura |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do Loop
multiplying by 10 raises the number by a power of 10 on each loop. 10^10
will be the number followed by 10 zereos if this really what you want. assume your value is 5 wouldn't your answers be: 5E10 5E20 5E30 5E40 5E50 -- Regards, Tom Ogilvy "Laura" wrote in message ... I want to take a value and multiply it by a nmber 10 times in a row. I then need to save that 10th value. Then I want to continue on until I get to 20 and then save the 20th value. I want to also save the 30th, 40th, and 50th value. Can I do this with a Do Loop? How do I pull out the values I need? Thanks, Laura |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
Loop ? | Excel Discussion (Misc queries) | |||
Loop | Excel Discussion (Misc queries) | |||
loop | Excel Discussion (Misc queries) | |||
vba loop | Excel Discussion (Misc queries) |