Finding median, mean and mode using ifs functions

Todd1963  wrote: ``I was instructed to find the mean, median and mode using the ifs functions.``

Or  m-a-y-b-e  they mean.... (wink)

Unless you want to waste your time with a lot of well-intentioned misdirection, I suggest that you post the complete instructions for the assignment verbatim, not your interpretation of it.  Ideally, attach an Excel file (not an image) with any data and formulas that you have.

Since this is a "level 300" Excel class, whatever that means, I presume the point of the exercise is to teach you something about Excel, not the statistics.  So it might help if you provide some context for the assignment.  In particular, what Excel functions and features is the class focused on now?  IFS etc?  Array-entered formulas?  Data Validation features? etc etc etc