Forum Discussion

Regan99's avatar
Regan99
Copper Contributor
Aug 06, 2022

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