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

 

[trungtb]

I has write incorrect my example. Because i cannot edit post. Please look my edit

    7,500,300 => 7,500,000
    7,520,200 => 7,500,000
    7,940,200 => 7,500,000
    7,240,300 => 7,000,000

If value after first comma greater than and equal 5 now value into 5 => If value after first comma greater than or equal 5 now value into 5
Thanks you so much

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	7500300	7500000
3	7520200	7500000
4	7940200	7500000
5	7240300	7000000
Data

Cell Formulas
Range	Formula
B2:B5	B2	=FLOOR(A2,500000)

 

[Joe4]

Try this formula:

=FLOOR(A1,500000)

EDIT: Too slow! Fluff sneaked in before me!

 

[trungtb]

How about

Fluff.xlsm
	A	B
1
2	7500300	7500000
3	7520200	7500000
4	7940200	7500000
5	7240300	7000000
Data

Cell Formulas
Range	Formula
B2:B5	B2	=FLOOR(A2,500000)

Sr it not working
When i enter value : 7,500,300 it change to 0 . I want it change 7,500,000

 

[Fluff]

Is that meant to be 7 1/2 million?

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

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

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 or equal ...

stackoverflow.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[trungtb]

Try this formula:

=FLOOR(A1,500000)

EDIT: Too slow! Fluff sneaked in before me!

Sr it not working.

Is that meant to be 7 1/2 million?

I found solution.

=INT(B2/1000000)*1000000 + IF(MOD(A1,1000000)>500000,500000,0)

 

[trungtb]

=INT(B2/1000000)*1000000 + IF(MOD(B2,1000000)>500000,500000,0)

 

[trungtb]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

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

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 or equal ...

stackoverflow.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Thanks you.

Is that meant to be 7 1/2 million?

Try this formula:

=FLOOR(A1,500000)

EDIT: Too slow! Fluff sneaked in before me!

Thanks you for help . Problem has solve on cross posted.