Square a number in Excel ?

Discussion in 'Microsoft Excel Discussion' started by Gary, Sep 4, 2003.

  1. Gary

    Gary Guest

    Could anyone tell me how to square a number in Excel ?

    Thanks
     
    Gary, Sep 4, 2003
    #1
    1. Advertisements

  2. Gary

    Andy Wiggins Guest

    In any cell:
    =2^2
    =3^2
    =4^2

    or cubed:
    =2^3
    =3^3
    =4^3

    etc
    --

    Regards
    Andy Wiggins
    www.BygSoftware.com
    Home of "The Excel Auditor" and "Byg Tools for VBA"



    "Gary" <> wrote in message
    news:2tH5b.263749$cF.82850@rwcrnsc53...
    > Could anyone tell me how to square a number in Excel ?
    >
    > Thanks
    >
    >
     
    Andy Wiggins, Sep 4, 2003
    #2
    1. Advertisements

  3. Gary

    Chip Pearson Guest

    Gary,

    Use a formula like

    =A1^2

    The ^ operator is exponentiation.

    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    www.cpearson.com



    "Gary" <> wrote in message
    news:2tH5b.263749$cF.82850@rwcrnsc53...
    > Could anyone tell me how to square a number in Excel ?
    >
    > Thanks
    >
    >
     
    Chip Pearson, Sep 4, 2003
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Fredrik Jansson

    Line break in cell, char(10) square settings?

    Fredrik Jansson, Oct 14, 2003, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    456
    Immanuel
    Oct 14, 2003
  2. Vince C.

    PBM: drag square disappeared in Excel 2000

    Vince C., Feb 6, 2004, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    599
    Gord Dibben
    Feb 6, 2004
  3. Sadik

    Square Root

    Sadik, Feb 11, 2004, in forum: Microsoft Excel Discussion
    Replies:
    7
    Views:
    323
    Stuart
    Jun 9, 2004
  4. Snoopy

    Autocorrect in Excel - "m2" (square meter notification)

    Snoopy, Jan 26, 2007, in forum: Microsoft Excel Discussion
    Replies:
    6
    Views:
    5,170
    Snoopy
    Feb 15, 2007
  5. PHPBABY3

    Excel prints page as tiny little square

    PHPBABY3, Apr 23, 2007, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    449
    Bob I
    Apr 24, 2007
Loading...

Share This Page