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!)
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!)
1 Reply
=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.
