# Excel Round off formula to get desired result

#### baidya91

##### Board Regular
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:

#### Johnny C

##### Well-known Member
=(ROUND(X*2.57/100,0)*100 should fix it

#### Joe4

=(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
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

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.