Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.

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.

Mike
2011-01-13 20:28:00
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 menuSet Cell: A1To Value: 10By 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 Seekwww.reading.ac.uk/web/files/its/solver2007.pdf
MAKEUSEOF VIDEO OF THE DAY
SCROLL TO CONTINUE WITH CONTENT
2011-01-13 20:23:00
Have you used the clipboard function for copy and pastehttp://www.lytebyte.com/2009/06/16/how-to-access-clipboard-in-word-and-excel-2007/http://www.dummies.com/how-to/content/using-the-clipboard-task-pane-in-excel-2007.htmlhttp://office.microsoft.com/en-us/excel-help/copy-and-paste-multiple-items-by-using-the-office-clipboard-HA010163602.aspxhttp://spreadsheets.about.com/od/exceltools/qt/070817clipboard.htm