Preview Formula Results in Google Sheets

Google has added a handy ability to Google Sheets; you can now view the result of any formula (including any potential errors) in real time, as you create the formula.

Simply enter your formula and watch the calculated result pop up above it in a ‘tool tip’ style container:

Click image to enlarge

Click image to enlarge