Get number at place value

Get number at place value

Generic formula 

=MOD(number,place*10) - MOD(number,place)

Explanation

To get the number at a specific place value you can use a formula based on the MOD function. By place value, we mean hundred thousands, ten thousands, thousands, hundreds, tens, ones, etc.

In the example shown, the formula in cell D8 is:

=MOD(B8,C8*10) - MOD(B8,C8)

The place is thousands (1000), and the result is 3000.

How this formula works

The MOD function performs the modulo operation. It takes a number and a pisor and returns the remainder after pision.

In this formula, we subtract one MOD result from another.

For the first MOD, we use the number with a pisor that equals the place value we want times 10. For the second MOD, we use the number with a pisor equals to the place value we seek. The formula is solved like this:

=MOD(B8,C8*10)-MOD(B8,C8)=MOD(123456,1000*10)-MOD(123456,1000)=3456-456=3000

Get number at place value

Generic formula 

=MOD(number,place*10) - MOD(number,place)

Explanation

To get the number at a specific place value you can use a formula based on the MOD function. By place value, we mean hundred thousands, ten thousands, thousands, hundreds, tens, ones, etc.

In the example shown, the formula in cell D8 is:

=MOD(B8,C8*10) - MOD(B8,C8)

The place is thousands (1000), and the result is 3000.

How this formula works

The MOD function performs the modulo operation. It takes a number and a pisor and returns the remainder after pision.

In this formula, we subtract one MOD result from another.

For the first MOD, we use the number with a pisor that equals the place value we want times 10. For the second MOD, we use the number with a pisor equals to the place value we seek. The formula is solved like this:

=MOD(B8,C8*10)-MOD(B8,C8)=MOD(123456,1000*10)-MOD(123456,1000)=3456-456=3000