Retrieving units and tens in Excel - Electronic Circuits Projects Diagrams Free

atferrari · 28th February 2007, 11:23 PM

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 · 28th February 2007, 11:42 PM

Try this:

=MOD(22768,100)

this gives the answer.

JimB

atferrari · 1st March 2007, 12:42 AM

Gracias Jim

That was it! Spanish name: RESIDUO().

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar
Title	Starter	Forum	Replies	Latest
Request for hep!!!	Pook	Micro Controllers	3	12th February 2006 02:33 PM

28th February 2007, 11:23 PM	#1
atferrari	Retrieving units and tens in Excel 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? __________________ Agustín Tomás In theory, there is no difference between theory and practice. In practice, however, there is.

28th February 2007, 11:42 PM	#2
JimB	Try this: =MOD(22768,100) this gives the answer. JimB __________________ Experience is directly proportional to the value of the equipment ruined.

1st March 2007, 12:42 AM	#3
atferrari	Got it! Gracias Jim That was it! Spanish name: RESIDUO(). __________________ Agustín Tomás In theory, there is no difference between theory and practice. In practice, however, there is.