The range of a set of values is defined as the maximum value minus the minimum value. Write a formula to calculate the range of values in N30:N75, rounded to the nearest integer.

Answer 1

Hello Max.

I'm not sure if this is what you are looking for.. Try this..

=INT((Max(N30:N75)-Min(N30:N75))

Hope it helps..