Thread: Round formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tony7659 Tony7659 is offline
external usenet poster
 
Posts: 32
Default Round formula

Also,

=ROUND(SUM(D53:N53),3)

No need to Ctrl-Shift-Enter it.

Tony.

(Click "Yes" if helpful to you)

"GIDRA" wrote:

I have this formula (below). Is there an easier way to do it ?
=ROUND(D53,3)+ROUND(E53,3)+ROUND(F53,3)+ROUND(G53, 3)+ROUND(H53,3)+ROUND(I53,3)+ROUND(J53,3)+ROUND(K5 3,3)+ROUND(L53,3)+ROUND(M53,3)+ROUND(N53,3)

Thanks.