Have you ever tried to copy numbers from one spreadsheet to another, only to discover that the cells you copied actually contained formulas? When you pasted them into the new location, each cell had an error instead of the number you wanted. Here are 3 different ways you can convert a formula into the number that is the result of that formula.
Archive for category All
Some people have experienced a problem running Sage 50 after installing the 2017.1 update. In the cases I’ve run across, Sage 50 opened without a problem after the installation finished. But the next time they try to launch Sage 50 they get the error “Sage 50 Accounting has stopped working.” All I’ve been able to […]
Sage 50 2017.1 New Features
Nov 21
On November 16, 2016, Sage 50 U.S. released the 2017.1 update to Sage 50. Sage is following through with their plan to provide additional cloud and mobility features in the Sage 50c (subscription) variant of the product, differentiating it from the traditionally licensed Sage 50. For some users, the additional features could make it worth […]
IF YOU USE THE “ALWAYS NOTIFY” FEATURE FOR CUSTOMERS, DO NOT UPGRADE TO VERSION 2017 YET! If you have been waiting to upgrade to version 2017 of Sage 50, you may want to wait a little longer. In my Sept 2016 newsletter I said that I hadn’t found any significant problems in Sage 50 2017 […]
Excel’s IF FUNCTION
Sep 30
If you what you want to display in a cell on a spreadsheet, or if the formula that you use needs to vary depending on the contents of a different cell, then the IF function is just what you need.
Recently I came across this question from a Sage 50 user: I’d like to add a full year budget column to the standard Income/Budget Statement so my board can keep their eyes on the end-of-year goal. Can you tell me how to add that column using the design tool within Reports & Forms? When I […]
Most of the Sage 50 version 2017 upgrades I’ve installed have gone smoothly. But on a few PCs it froze up on “Step 1 of 3, Installing Pervasive” so I thought I’d pass along this tip for how to resolve this problem. W3dbsmgr.exe is the database service manager for Pervasive, the database engine that Sage […]
Data validation may sound complicated, but it’s just a way to apply rules to a cell to make sure good (valid) data is being entered. How can you use this? You can set data validation for a cell to only accept a certain type of data such as date, time, numbers, or whole numbers. You […]
What’s New in Sage 50 2017
Jul 15
July 12, 2016 was the official release date for Sage 50 Accounting 2017, US version. Over the next few weeks, those of you with a current subscription or Business Care plan will see the upgrade show up as an automatic update, just like the 2016.1 and 2016.2 updates, or payroll tax updates. As usual, the […]
It’s always important to know the relationships and dependencies between cells on your spreadsheet. If you edit a cell, which other cells will be affected? And which cells does a particular formula look to? Both questions are easily answered with the Trace Dependents and Trace Precedents buttons. To find out which cells/formulas refer to (are […]
