=ROUND function

[kingshuk963]

13.13​

25.33​

26.32​

75.12​

81.21​

#VALUE!​

how to use the round function to get the round figure in the result. pls help.

round function.xlsx
	A
1	13.13
2	25.33
3	26.32
4	75.12
5	81.21
6	#VALUE!
Sheet1

Cell Formulas
Range	Formula
A6	A6	=ROUND(A1:A5,0)

 

[cortexnotion]

Try =ROUND(SUM(A1:A5),0)

 

[kingshuk963]

thank you @cortexnotion for the help. it works.