How to round value by specific value after decimal and change all value to zero after round

[trungtb]

I use excel and i have question.
I have value look like

7,500,300

If value after first comma less than 5(it 5 on my case) now round value into 0.
If value after first comma greater than and equal 5 now value into 5

Example:

    7,500,300 => 7,500,000
    7,5200,200 => 7,500,000
    7,9400,200 => 7,500,000
    7,2400,300 => 7,000,000

I using command look like :

=IF((VALUE(MID(7,9400,200,FIND(",",7,9400,200)+1,1))>=5),ROUND(7,9400,200),ROUNDDOWN(7,9400,200)

But it not working.

Please help me. Thanks you

 

[Joe4]

Our formula returns the exact same values as your formula:

I am guessing maybe that you did not adjust the ranges in our formulas to match your actual set-up.
You gave us no indication what column your original values are in, so we assumed column A.
But it looks like from your last formula, they are actually in column B.
So you would need to change the range references in our formulas.

You could got with your longer formula, but ours is much shorter and simpler!