Join Dennis Taylor for an in-depth discussion in this video Using the FORMULATEXT and N functions for worksheet and formula documentation, part of Excel Tips Weekly.
- View Offline
- Providing documentation for a worksheet…is sometimes a cumbersome process,…and not exactly exciting.…But let's say, that in this worksheet,…you've got some formulas,…and you'd like to make sure that…others who are using it understand what's going on.…I've got formulas in column H,…let me zoom in by holding down…ctrl and moving the mouse wheel.…Formula in column H,…that in effect says, bonuses are going to be achieved,…by one of two methods, possibly both.…If your job rating is over 3,…you get a $2000 bonus.…
If your years of service are over 14,…you get a $500 bonus.…And notice how they're being added,…so possibly, you'll have a bonus…of as much as 2500,…or if not, maybe only 2000, or only 500.…We see some of those results below.…But others might be looking at this,…and we want to expand this,…and explain what's going on.…So, double clicking here.…A function called N,…think for the word note, maybe.…+n, as you type it,…doesn't have to be capitalized.…
Then in (",…and practically anything you wanna type.…So, this is a Special bonus, just for 2015,…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.