Rounding Error

[EverClever]

Hello All,

I need to round to the nearest .5 in the formula's below and get the same "Too Few Arguments for this function" error message. The only difference in the formula's are where the rounding increment is placed; 1st formula is in the middle and the 2nd formula is at the end.

=MROUND(F211+H211+J211+L211),0.5/COUNTIFS(F211:L211,">0",F211:L211,"<100")

=MROUND(F211+H211+J211+L211)/COUNTIFS(F211:L211,">0",F211:L211,"<100"),0.5

I Can't figure out what's missing!

Thank you!

Patrick

[MrShorty]

It looks like one of the hardest, and yet most common kind of formula error. Count/match your opening and closing parentheses. I think you need more parentheses to fit everything together.

[Loganeb]

For the first one:

Please Login or Register  to view this content.

[EverClever]

Mr. Shorty,

Thanks for your input but I counted the parenthesis pairs and there are 2 left and 2 right parenthesis so they're matched up.

Patrick

[MrShorty]

But did you take careful note of the location of those parentheses? If you look at Loganeb's correction, you will note that he has the same number of parentheses, but he moved the first close parenthesis out to include the 0.5 argument that belongs with the MROUND() function.

If I understand what the 2nd function is supposed to do (and I'm not sure I do), the 2nd function needs another pair of parentheses to offset the entire thing =MROUND((currentformula),0.5)

[newdoverman]

I think that these are what you want.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[EverClever]

Mr Shorty,

I tried Loganeb's solution and that got rid of the "Too Few Arguments" error but it does not round the number at all. The result is stuck at 11.25 and needs to be
11.50.

Patrick

[MrShorty]

That's because the first variation computes the indicated sum, rounds it, then divides by the countif. Perhaps you are looking for newdoverman's second suggestion (with the additional parentheses around the entire function)?

[EverClever]

newdoverman,

Your 2nd formula worked! Thank you so much!!!

Patrick

[newdoverman]

You're welcome. Thank you for the feedback.