Retrieving units and tens in Excel

[atferrari]

Given a result of a previous calculation, (always positive and > 1000) I want Excel to show in another cell just the units and tens of that result.

Let's say I have 22768.

I need Excel to show just 68 (not as text but as a numeric value).

The value 22700 is unknow beforehand thus no substraction possible.

Any idea how to obtain that?

 

[JimB]

Try this:

=MOD(22768,100)

this gives the answer.

JimB

 

[atferrari]

Got it!

Gracias Jim

That was it! Spanish name: RESIDUO().