If statement help

L

lschuh

I want to average a group of numbers. I am using 1-5. If the average
exceeds 5.0 I want the value to return 5.0 if not then I just want the
average of the group of numbers. I wrote the following and the formula works
if true but returns a "false" if false.
=If(average(g9:g19)>5.0,5.0,Average(g9:g19)

I know the above is incorrect. The formula works on the first part but if
false if multiplies the second average.
 
E

Elkar

You don't really need an IF Statement for this. I think the MIN() function
will work for you.

=MIN(AVERAGE(G9:G19),5.0)

This returns the lowest (minimum) value between 5 and the average of your
range.

HTH,
Elkar
 
Top