Overview
I'm working on a mathematics question and need an explanation and answer to help me learn.
Prepare a spreadsheet using hypothetical data showcasing the application of the following functions:
Conditional
IF function – check if a condition is met
NESTED IF – Multiple if conditions
Conditional Formatting – Format Excel Cells based on criteria
COUNTIF – Count cells in range which meet a certain criteria
SUMIF – Sum range based on criteria