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:
    679
    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:
    795
    Gord Dibben
    Feb 6, 2004
  3. Sadik

    Square Root

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

    A Square is Showing Instead of a Period for a Currency.

    Guest, Jan 28, 2005, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    226
    Dave Peterson
    Jan 28, 2005
  5. Twidley
    Replies:
    6
    Views:
    625
    Ron Rosenfeld
    Dec 16, 2006
  6. Snoopy

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

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

    Excel prints page as tiny little square

    PHPBABY3, Apr 23, 2007, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    683
    Bob I
    Apr 24, 2007
  8. Square cell values, repost to same cell

    , Sep 19, 2007, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    211
Loading...