I am trying to apply the ROUNDDOWN formula to an averaging formula and it is saying I have too few arguments. Can any of you see what I'm missing? Here's my formula:
=ROUNDDOWN(AVERAGE(B31,F31,J31,N31,R31,V31,Z31))
thanks
I am trying to apply the ROUNDDOWN formula to an averaging formula and it is saying I have too few arguments. Can any of you see what I'm missing? Here's my formula:
=ROUNDDOWN(AVERAGE(B31,F31,J31,N31,R31,V31,Z31))
thanks
You need to state to how many digits your formula should round down. If you want it to round down to no digits, then:
=ROUNDDOWN(AVERAGE(B31,F31,J31,N31,R31,V31,Z31),0)
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
That worked. Thank you!
You're welcome. If you could mark this thread as solved, it would be a great help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks