Hi All,
how can I create a formula for Rounding an Average Value? for Ex: if get the average value for 2 numbers for 4,3 is 3.5 for this i need to show 3 only. above 3.5 only i need to show 4.
how can i achieve this.
Thanks
Hi All,
how can I create a formula for Rounding an Average Value? for Ex: if get the average value for 2 numbers for 4,3 is 3.5 for this i need to show 3 only. above 3.5 only i need to show 4.
how can i achieve this.
Thanks
Hi
try the MROUND function
Excel along with general mathematical convention rounds .5 up and not down
then it is just round(average(4,3),1)
otherwise
=(MOD(AVERAGE(A1,B1),1)>0.5)+INT(AVERAGE(A1,B1))
In A1 Cell
4
In B1 Cell
3
In C1 Cell
=ROUND(AVERAGE(A1:A2),0)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Pepe,
i have used like the below.
=MROUND(AVERAGEIF(A1:B5,A7,B1:B5),1)
but it gives for 3.5 as 4. but i need the 3 only. Please advise.
Best,
V
also same only if i use INT
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
attached is the current formula
In B7 Cell
=INT(AVERAGEIF(A1:B5,A7,B1:B5))
In B8 Cell
=INT(AVERAGEIF(A1:B5,A8,B1:B5))
for the attached average value for BofA - is 4.6. so for this, I need to display as 5 now it's showing the 4 only. Please advise.
Why did you not use the formula I provided or amend it, since there was no mention of average if in the original post?
=(MOD(AVERAGEIF(A1:B5,A8,B1:B5),1)>0.5)+INT(AVERAGEIF(A1:B5,A8,B1:B5))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks