Nesting AVERAGE and ROUND functions

Occasional Visitor
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!)
1 Reply

@_Natali_ 

=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.