Click on Multiply in the Operation section.The result in cell B1 will be the value of B1-A1 which is 85-25 = 60.Click on Subtract in the Operation section.Hence we get 85 in cell B1 which is 25+60. You will find the result as the addition of both numbers in cell B1.The Paste Special dialog box will appear.From the shortcut menu, select the Paste Special option.Select the cell B1, right click with the mouse.Copy the cell by pressing the key Ctrl+C on your keyboard.We need to add 25 and 60 without using any formulae. Let’s take an example to understand that how we can add, subtract, multiply and divide the numbers without using formulas in ExcelĬell A1 contains number 25 and cell B1 contains the number 60. Paste Special: You can use the Paste Special feature to paste specific cell content or attributes such as formula, formatting, comments, etc. If we need to add, subtract, multiply and divide the numbers without using formulas, we can use the Paste Special option in Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |