Forum Discussion
Nesting AVERAGE and ROUND functions
Hi! I have a question. How to nest the AVERAGE function and the ROUND function? Thank you in advance! (I'm sorry if my English is not correct!)
=ROUND(SUM(IF(A7:A21>AVERAGE(A7:A21),A7:A21)),0)
For example you can calculate the rounded sum of all numbers that are above the average. Enter formula with ctrl+shift+enter if you don't work with Office365 or 2021.