Forum Discussion
Finding median, mean and mode using ifs functions
Hello, I am a student in a 300 level excel spreadsheet class. In my over 30 yr professional career I have never had to use Excel. In my assignment from last week I was instructed to find the mean, ...
Using IFS to calculate mean etc. makes no sense. Perhaps they meant using IFS to return one of these three statistical measures?
See the attached sample workbook.
or maybe they mean to use the IFS statement to calculate those values on only certain data, i.e. data that meet a certain criteria?
but if this is some academic exercise then in addition to IFS what other functions are allowed? can you use sum and count?
but if this is some academic exercise then in addition to IFS what other functions are allowed? can you use sum and count?