Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round formula
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round formula
=SUMPRODUCT((ROUND(D53:N53,3)))
If this post helps click Yes --------------- Jacob Skaria "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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round formula | Excel Worksheet Functions | |||
How not to round a formula | Excel Discussion (Misc queries) | |||
Round up Formula Help | Excel Discussion (Misc queries) | |||
How do I NOT round off in a formula | Excel Worksheet Functions | |||
formula to round up? | Excel Worksheet Functions |