EXCEL COURSE PART ONE - FORMATTING A DATABASE

Formulas/Calculated Field. Type Bonus Amount for the Name. Enter the following formula = IF('Order Amount'>20000, 2000, 1000) Click the Add button and then click OK. Add the Bonus Amount to the desired Row or Column. Adding the Average, Max and Min subtotals. ................
................