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: http://office.microsoft.com/en-us/excel-help/use-equation-editor-in-excel-HP010215799.aspx)

    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
    http://www.reading.ac.uk/web/files/its/solver2007.pdf