How to round numbers both up and down in one formula

[Glorpy]

Hi there guys. I am trying to make a simple formula in which you must add 4 numbers and then get the average of them. Seems simple right? Well obviously I am missing something here. Here is what I am doing

I have the 4 numbers: 9 8 6 8

Now I want to divide these by 4 and put them into a total cell.

I can show you in an attachment file. But basically what is happening is I am going =c3+e3+g3+i3 / 4 and I am getting a number along the lines of 5 5/10.

[Sam Capricci]

Try =sum(c3,e3,G3,i3)/4

[ajob]

Place all the numbers to be added inside brackets and then divide by 4.

e.g formula for total cell (C3+e3+g3+i3)/4 = 7.5

[Glorpy]

Thank you guys very much. The sum thing seemed to do the trick and I will have to try the one you said ajob. Now I was just wondering if there was a way to round the total number to say 7 if the answer is 7.25, would there be a way to check to see if the number is >= 7.50 and round it up or down depending? I am still learning the program myself and watching video tutorials. Thanks for all the help in advance

[boopathiraja]

Hi Welcome to the forum , Please edit the title to comply with forum rules..

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Sam Capricci]

for mine you can add to it…=rounddown((sum(c3,e3,G3,i3)/4,0) which should round it down to the lowest whole number. If you want it rounded up use roundup and if you just want it rounded based on the nearest .5 then use round.

EDIT: BTW, didn't notice the title issue. sorry or i would have called OP on it.

[Glorpy]

My bad, I have a really bad habit of not reading stuff like that even though I have all the time in the world. My bad sorry guys. I went ahead and changed the title to a better one.

[boopathiraja]

Thanks for that