The Calculate command will not insert the answer into your document.

Thanks.The result is displayed on the left side of the status bar at the bottom of the Word window.

$microsoft word math functions$

and so on… If you have any other query regarding excel you have to logon this site and submit your query in comment box of any post. If you want to add 1 in previous date then you have to first type today() function or you can also type any date in cell A1 then you have to type this formula in next cell =A1+1 then press enter now drag it till target cell address… you will get result like, , ……. This however changed the dates to numerical values, so you will need to change the format back to date. I needed to add one day to each date, so I put the number 1 in general format, copied it and then used paste special. Just tired this with dates, seems to work though you need to change the cell format. Subscribe to our Youtube Channel for more tutorials. “Use Paste Special to insert static or linked data into Excel.”

While there are easy ways to find this kind of information in more traditional means - like using a calculator - the Paste Special box can be a tremendous time-saver and can be advantageous to virtually any business. This can show how much all of your products will cost during the sale. Copy 0.80 from an empty cell on your spreadsheet and use the “multiple” paste special operation. For example, say your company is running a promotion that decreases the price of your products by 20 percent. If you have lots of rows and/or columns of data that you with to update in the same way, the paste special tool is the easiest way to accomplish this. As the video above shows, you can do basic mathematics with this tool without using any complicated formulas.

Microsoft word math functions