![]() |
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 |
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 |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com