Excel Round off formula to get desired result

baidya91

Board Regular
Joined
Jun 1, 2016
Messages
128
Which uniform excel round off formula should I use to get the following result by multiplying certain figures by 2.57?:

6600*2.57 = 17000

7680*2.57 = 19700

11040*2.57 = 28900

12750*2.57 = 33400
 
Last edited:

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,771
Office Version
365
Platform
Windows
=(ROUND(X*2.57/100,0)*100 should fix it
You are missing a right parend in your formula, but Excel already has a function to do this called "MROUND", i.e.
Code:
=MROUND(A2*B2,100)
baidya91,
Are the last two entries typos?
11040*2.57 = 28900

12750*2.57 = 33400
I do not see how you would ever get to those amounts (I get 28400 and 32800, respectively).
If they are correct, you are going to need to explain your logic on how you arrived at those amounts.
 

baidya91

Board Regular
Joined
Jun 1, 2016
Messages
128
Yes, I cannot round off the last two cases. But it is there in a certain table. So I ask such a question. I thought experts like you might know how to fix it. But I have found no logic in it.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,771
Office Version
365
Platform
Windows
Yes, I cannot round off the last two cases. But it is there in a certain table. So I ask such a question. I thought experts like you might know how to fix it. But I have found no logic in it.
I do not understand what you are saying.

Are you saying that there is a lookup table? If so, then you may be able to use a VLOOKUP formula to look it up.
See: https://www.excel-easy.com/examples/vlookup.html

If that does not solve your issue, you are going to provide us with more details.
 

Forum statistics

Threads
1,085,513
Messages
5,384,111
Members
401,881
Latest member
Dato

Some videos you may like

This Week's Hot Topics

Top