DIVIDING AND DOUBLING EVERY THREE HOURS USING MICROSOFT EXCEL

In an experiment bacteria divides and doubles every three hours. How many bacteria will there be at the end of one day (24 hours)?

To calculate the total amount of bacteria after 24 hours:

1. Enter values from 1 to 4 in cells B2:B8.
2. Select cells C2:C8 and type the following formula: =A2^(24/B2).
3. Press <-Ctrl+Enter->.
4. From the Format menu, select Cells and the Number tab.
5. Choose Number from Category.
6. Set Decimal places to 0, and click on the Use 1000 Seperator check box.
7. Click OK.

DIVIDING AND DOUBLING EVERY THREE HOURS USING MICROSOFT EXCEL

Note:  To insert the ^ character, press the <- ^ -> key on the keyboard followed by a <- Space ->.

Microsoft Excel Tutorials, MS Excel Tutorials, Dividing and Doubling Every Three Hours using MS Excel, Microsoft Excel Tutorials, Formulas in Excel, Basic Functions in Excel, Microsoft Excel Video Tutorials