How can I insert formulas in Excel?

johannes January 13, 2011
Pinterest Stumbleupon Whatsapp

I would like to put some formulas, like I can make in Word with equation tools, into Excel. I can’t copy and than paste it, but maybe it is possible to do it on some other way.

  1. Mike
    January 13, 2011 at 8:28 pm

    I'm not entirely sure if I understand your problem correct.

    For Office 2007 and later you should be able to copy paste equations form Word into Excel (as described here:

    For older version you probably have to type it in using operators and functions Excel can understand e.g. "35^2" for square, SQRT(35) for square root (?).

    If you are trying to solve mathematical problems e.g. x^2 * 100 / 20 = 10 you will have to split it up and use "Goal Seek" ... let's solve "x^2 * 100 / 20 = 10" as an example:

    first put the following in cell A1 "=B1^2*100/20"
    (notice x has to substituted with a valid cell)

    start "Goal Seek" from the Tools/Extra menu

    Set Cell: A1
    To Value: 10
    By Changing Cell: B1 (the cell we are using for x)

    click OK and voila, the correct value for x is now in cell B1

    Here is a tutorial for Goal Seek