atferrari Well-Known Member Most Helpful Member Feb 28, 2007 #1 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?
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 Super Moderator Most Helpful Member Feb 28, 2007 #2 Try this: =MOD(22768,100) this gives the answer. JimB
atferrari Well-Known Member Most Helpful Member Feb 28, 2007 #3 Got it! Gracias Jim That was it! Spanish name: RESIDUO().