Thread: Round formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default Round formula

1. =SUMPRODUCT(ROUND(D53:N53,3))
ENTER it

2. =SUM(ROUND(D53:N53,3))
this is an array-formula so CTRL+SHIFT+ENTER it

On 13 Maj, 10:03, 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(K 53,3)+ROUND(L53,3)+ROUND(M53,3)+ROUND(N53,3)

Thanks.