Nested Equations

[Michelle Melville]

Hey guys, I'm having some trouble writing an equation for a homework assignment. I'm supposed to Find the average of a row (E6-P6) and then round that to the nearest $10. I keep getting pop-ups that my formua is wrong, and I have no idea where to go from here. Any help would be appreciated.

[#2]

Try below formula:-

=MROUND(AVERAGE(E6:P6),10)

Regards,

DILIPandey

[#3]

Almost! I replaced the 10 with -1 and it worked the way it should've. Thank you!!!!!!

[#4]

Hi Michelle

-1 shouldn't work?     are you sure the formula is correct?

[#5]

if only AVERAGE(E6:P6) is not negative