Find Square Inch Of A Cell

  • Thread starter Thread starter LUIS CORDERO
  • Start date Start date
L

LUIS CORDERO

HELLO, NEED SOME HELP,
IF IN CELL A1 IS THE SIZE 52X52 HOW CAN I GET B2 TO = THE SQUARE INCH
OF THAT SIZE
EXAMPLE 42X42 WILL EQUAL 1764 OR 62X62 WILL EQUAL 3844
ALL DONE BY HAND RIGHT NOW
I LOVE THIS SITE AND ALL THE GREAT PEOPLE THAT ARE HERE TO HELP

MUCHO THANKS
 
Please turn off the caps lock, it is considered shouting

=LEFT(A1,SEARCH("x",A1)-1)*MID(A1,SEARCH("x",A1)+1,255)
 
Back
Top