View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I quadruple numbers starting with 1, 2?

Quadruple means multiply by 4.

Your example sequence shows numbers doubled.

Which do you want?

Quadrupled would be 1,4,16,64

A1 contains 1

A2 contains =A1*4

Drag/copy down column A

Doubled would be 1,2,4,8 as our example.

A1 contains 1

A2 contains =A1*2


Gord Dibben MS Excel MVP

On Fri, 15 Sep 2006 09:43:02 -0700, frenchy
wrote:

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