Hello folks!
I have a problem with rounding and sums.
What I need is to:
1.Round product of two numbers on 2 decimals (I don't need more decimal places)
2.Then Sum all of these products on 2 decimals.
What I am guessing that probably Sum of these numbers is primary executed and then Product of those numbers is Rounded, because I'm getting wrong numbers.
I need first to round those numbers and then sum them.
Hope someone will help me.
Thanks!
Hi,
Try:
=SUMPRODUCT(ROUND(A1:A10,2),ROUND(B1:B10,2))
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank you for your help.Originally Posted by Domski
If I use this function you gave me I only receive empty cell
I tried some of solutions like this but it didn't worked (don't know what this empty cell means).
In my example I have 3 Sums
0.00400
0.00400
0.00400
rounded on 2 decimals it should be:
0.00
0.00
0.00
and Sum of these sums above should be
0.00
but I am getting the result
0.01
I assume that excel is first doing Sum of results then Round of each result.
Hoping this will explain my problem.
Thanks a lot!
Can you provide a sample workbook?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I solve the problem.Formulas were right but problem was in formating made by my friend who asked for my help and who gave me a file
Dom, thanks a lot man!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks