Rounding to the nearest ten

Rounding Large Numbers Nearest Ten Thousand Nearest Ten Million

http://www.aaamath.com/g41d_rx1.htm

http://www.mathatube.com/rounding--w-to-ten-thousand.html

How to Round to the Nearest Ten Thousand

you can't because it is not near ten thousand the nearest is zero
if it was 13,999 then it has a chance of rounding to 10,000

rounded to the nearest thousand 65,000
rounded to the nearest ten 64,780

Rounded to the nearest hundred: 82,600
nearest ten: 82,600
nearest thousand: 83,000
nearest ten thousand: 80,000

Round to which place value?
To the nearest million: 1,000,000
To the nearest hundred thousand: 700,000
To the nearest ten thousand: 740,000
To the nearest thousand: 741,000
To the nearest hundred: 740,700
To the nearest ten: 740,690

812218

They both are. 3,642 rounded to the nearest hundred is 3,600. 3,642 rounded to the nearest thousand is 4,000. Rounded to the nearest ten, it's 3,640.

What do you want to round it to? To the nearest unit, 41 is 41. To the nearest ten, 41 is 40, to the next highest ten, 50. To the nearest hundred, 41 is 0, to the next highest hundred, 100.

Here is your formula

=IF(A1 < 25,10/100 * B1, 5/100 * B1)

A1 is the Age of client
B1 is the car value