Forum Discussion
Regan99
Aug 06, 2022Copper Contributor
Excel equations
Hi, I’m felling my way around excel for the first time since high school.
I have the basic equations and averaging sorted but what I would like to do is have a line added up and averaged while ignoring the decimal but still have the decimal shown on the spreadsheet. Ie
99.5 98.2 97.9 = (a total of) 294 (an average of) 98
currently my total is 295.6 and average is 98.533
Would love to know if this is possible
2 Replies
- PeterBartholomew1Silver Contributor
= SUM(INT(numbers)) = AVERAGE(INT(numbers))- Regan99Copper ContributorThanks, I have a go.