Insert Calculations and Formulas into Word | Microsoft Word Tutorials

[@_indomitus_]

I have searched and searched and finally came across this guide. What an absolute gem of a guide.

[@thisoldvegan62]

Two things to look out for: First, if there are numbers in the heading row, they might be included in the calculation. (Avoid using numerals as your headings.) Second, if you change any of the numbers, you should select the entire table and press F9 to recalculate.

[@sheriffhaidara7232]

Thanks 🙏

[@softwaredynamicsolutions]

Thank you for sharing

[@LisaDoe]

Thanks for watching! : )

[@TomMyfield-tr2tg]

Found it: In your lesson plan, title the first column in your Lesson Plan Word doc table to be "Duration" and the next column (to the right) to be "Time", meaning total elapsed time in the lesson at that point in your progress. The first column (left-most) is where you put the amount of time in minutes that that part of the lesson should take. The column to the right of that shows the total time elapsed in the lesson at that point. The cells in this column all get the Formula "=MAX(ABOVE)+SUM(LEFT)" added to them. To ensure the time gets updated when you add or change a part of the lesson, just click the line at the top of the header for the totals column and hit "F9" (in Windows computers). This recalculates the whole totals column. I'll make a video. No more manually changing the times in lesson plans! ☺☺

[@SAMUELAMOAH-ms3gp]

Thanks for the help 👍

[@bel-tlmdz5247]

Simple, nice and beneficial lesson. Thanks

[@LisaDoe]

Glad you liked it!

[@ByahingJoPH]

Thanks big help...

[@JunairahIslam]

very nice effective

[@wilbertmlyuka5723]

Asante sana madam nimekuelewa mno. Japo umetumia English

[@jscomputergenius3834]

🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣

[@TomMyfield-tr2tg]

Shame Word doesn't let you just two numbers together, e.g- the value of this cell with the value of the cell immediately above. Seems like it's locked in to only add either rows or columns.

[@nathan6899]

Thank you.

[@Tobias-ig8kq]

Thank you!!

[@patahao9300]

Thank you very much for your video.

[@philsimpson2854]

Brilliant!! Thank you , although if you change the numbers after inserting the formula, the total doesn't update. am i doing something wrong? :)

[@gaayathritradings5135]

it is very helpful with in minute

[@anilg28]

Thanks for such a educating content. Question how to multiply values in two column in the same row (overlooking all the information - just the numbers for 25 pieces * $100 each)? Also how to get sum total of all such sums in the last final total? Finally upon correction in any sum of any row, how to get correct Final Sum total of all the rows (final total remembers the last sum total and adds the new total again. Eg 10*50 = 500 then if you correct and do 11* 50 =1050 (how to correct this error)

[@maverick19_]

Hi, thanks for the awesome content, I tried that but for some reason my average formula gives a different value and not the average. Any advice?

[@user-dn9vd9xg9p]

Mine is not auto-calculating. I have to right click and update to make it calculate. Any suggestions?

[@araposkulo]

I am trying to find a way to have constantly calculate what there is above/right/left (similar to excel) but doesn't seem possible

[@smitshah2870]

How to add selective figure in ms word

[@treasuresnownthen]

Lisa, new subscriber here, Love your vids! I do have a question though. Trying to help a friend. Need to paste a one line excel with 2 formulas into a word doc. When I paste it into the word doc, it disables the formula...I carefully follow your instructions on pasting the workbook object and still it will not work. I am tearing my hair out. Any advice?

[@LisaDoe]

Thank you for your lovely comment. Take a look at this video, I think it might help - kzbin.info/www/bejne/d5_ZYo2NjrqDps0

[@taffyboy1978]

I click layout but there is no option formula on mine??

[@davidpatkovik648]

What about multiply , how to do it

[@cjay233]

I did this, but when I change a number, the calculation no longer worked.

[@Itwinasilele]

CHEERS

[@AimableBisengimana-ct2sk]

❤

[@harechurrahman9680]

why is it not being to my pc? can yo tell me solution?

[@slicesofsib5572]

If there are number counts missing in table cells, it does not work just FYI.

[@advancedquality5336]

I did this, but when I change a number, the calculation no longer worked.

[@woefie1234]

Hit F9 or right mouse button -> update field in which the formula is placed