Learn How To Boost Your Knowledge
With Some Important Formulas
| Name | Formula |
|---|---|
| Serial Number | =SEQUENCE(COUNTA(B:B) |
| Percentage Increase | =100,000 * (1 + 10%) = 110,000 |
| Percentage Decrease | =100,000 * (1 - 10%) = 90,000 |
| Extract Gross Amount | =116,000 / 116 * 100 = 100,000 |
| Extract Increased Amount | =116,000 / 116 * 16 = 16,000 |
| Schedule Time | 9:00 + 15 / 1440 = 9:15 |
| Choose Columns | =CHOOSECOLS(B2:E5,2,4) |
| Top Five | =TAKE(SORT(E8:E15,,-1),5) |
