Hi All,
I am looking to add an average function with a round function but with a twist.
I need to average cells A1:A10, then round up, but to round up when the number is greater than or equal to ".6" or to round down when the number is less than ".6"
i.e.
Cell calculation =< 4.5 (result is 4)
or
Cell calculation => 4.6 (result is 5)
Any help please