How can I insert formulas in Excel?

johannes January 13, 2011

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