View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JC JC is offline
external usenet poster
 
Posts: 9
Default How do I quadruple numbers starting with 1, 2?

On Fri, 15 Sep 2006 18:00:59 +0100, "Roger Govier"
wrote:

"frenchy" wrote in message
...
How do I quadruple numbers after I start with 1 and then 2 to come up
with 4,
8, etc.?



Hi

You need to raise the number to the power of using the exponentiation
symbol ^

However, you can't start with 1 as
1^4 = 1 x 1 x 1 x 1 which = 1

2^3 = 2 x 2 x 2 = 8


Roger,

You need to look up the term 'quadruple' in your dictionary. To quadruple a
number you make it 4 times as big NOT raise it to the 4th power.

To answer the question you do the following:-

A B
1 =4*A1
2 =4*A2
3 =4*A3
4 =4*A4
5 =4*A5

etc until you reach the end of the numbers that you wish to quadruple.
--

Cheers . . . JC