hey im so confused about average function. i have data in different column one is 16 and the other was 17 how to find the average of those values??im using AVERAGE function but it generated 17 instead of 16.5 and how to find the right answer 16.5 and how to round downed the answer to become 16??thanks in advanced
Last edited by mtsf; 11-11-2011 at 03:31 AM.
hello
try
Assuming
A1 = 16
A2= 17
0 = whole number you can change it.
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
i have try with floor function and also ur function and it work. thanks a lott..
Last edited by mtsf; 11-05-2011 at 04:43 AM.
Your mostly welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks