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

    Square Root

    Sadik, Feb 11, 2004, in forum: Microsoft Excel Discussion
    Replies:
    7
    Views:
    807
    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:
    224
    Dave Peterson
    Jan 28, 2005
  5. Twidley
    Replies:
    6
    Views:
    602
    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,121
    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:
    678
    Bob I
    Apr 24, 2007
  8. Square cell values, repost to same cell

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