You can edit the formula by modifying it on the formula bar or by double-clicking the cell containing the formula and editing it in the cell. The result will appear in the cell containing the formula. When you are done entering the formula, press the Enter/ Return key on your keyboard and the difference should appear (see below).Ĭ. After that enter the – sign and click on the cell containing the second value. Ever since I updated to Mac OS X Mavericks 10.9 whenever I launch a Microsoft Excel file from the dock, it opens a copy of the file but not the original file. If you prefer to select the cells instead of entering the cell references manually you can start the formula by typing the = sign in the cell or the formula bar and then clicking on the cell containing the first value. With results cell selected you can use the Functions text box to enter the formula you wish to use, in this case the formula described above. You can enter the formula in the cell where you wish the results to appear, or…ī. There are two places where the formula can be entered.Ī. It is important that the equals ( =) sign precede the cell references (equals sign always goes first when composing a formula) and that you use the minus ( –) sign between the two cell references. To subtract a number in Excel you will need to write out a formula that reads as follows:Ĭells A and B refer to a specific cell on the spreadsheet so if the first value you wish to use in the formula is in cell D1 and the second value is in D2 your formula should look like this: The 10th release of the Apples OS X operating system is available now for absolutely free to anyone wishing to upgrade, according to Apples senior vice president of engineering, Craig Federighi. Click the cell where you would like the difference (the result) to appear.Ģ. I was using Office 2011 on Macbook 13' (around 2010) running Mac OS X 10.6.8 and now I switched to the new MacAir running Mac OS X 10.9.4 The problem is I open the same excel file but they display differently between the two macs. By upgrading to OS X Mavericks, you can take advantage of the new apps and features including, iBooks, Maps, energy efficient features, and more.
#EXCEL FOR OS X MAVERICKS FOR MAC#
Software/Hardware used: Office 2011 running on Mac OS 10.6, but the guide should apply to all versions of Excel.ġ. Apple released OS X Mavericks software update for Mac computers.
#EXCEL FOR OS X MAVERICKS HOW TO#
In the following steps I will show you how to create a formula in Excel that a cell from another to provide you with the difference. If you are new to Excel and unfamiliar with Excel’s built-in functions, specifically subtraction you will find this guide useful.
0 kommentar(er)
