• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Engineering Functions > Excel in Practice

Excel in Practice

To really take advantage of formulas or functions, the best practice is to create dynamic scenarios. This means using cell referencing. When you hard-code numbers in functions or formulas, you have to change the numbers directly in the formula for new results. If you use cell referencing, you can set up tables and change the numbers in the table and the formula will respond. It also makes it easier to understand the variables included in the formula. Notice the example in Figure 9.15. The binary numbers are set up in column B, the Places in column C, the BIND2DEC result in Column D, and the formula in Column E references the cells in D8 and C8 as shown.

Figure 9.15. Use cell referencing with formulas so you can create changes with dynamic results.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint