From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Using the FORMULATEXT and N functions for worksheet and formula documentation

Using the FORMULATEXT and N functions for worksheet and formula documentation - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Using the FORMULATEXT and N functions for worksheet and formula documentation

- [Instructor] Providing documentation for a worksheet 2 is sometimes a cumbersome process and not exactly exciting, 3 but let's say that in this worksheet, 4 you've got some formulas and you'd like to make sure 5 that others who are using it understand what's going on. 6 I've got formulas in column H. 7 Let me zoom in by holding down control, 8 moving the mouse wheel. 9 Formula in column H, that in effect says, 10 bonuses are going to be achieved by one of two methods, 11 possibly both. 12 If your job rating is over three, you get a $2,000 bonus. 13 If your years of service are over 14, you get a $500 bonus, 14 and notice how they're being added. 15 So possibly you'll have a bonus of as much as 2,500, 16 or if not, maybe only 2000 or only 500. 17 We see some of those results below. 18 But others might be looking at this 19 and we want to expand this and explain what's going on. 20 So double clicking here, a function called N.…

Contents