Using the FORMULATEXT and N functions for worksheet and formula documentation

- 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,…