Can I reduce (101.25) to only what's *right* of decimal? (25)
hi
=MOD(A1,1)
this will get you what is right of the decimal which is .25. however your
example was 25 so just multiply by 100.
=MOD(A1,1)*100
adjust cell reference to suit.
regards
FSt1
"jay45940" wrote:
Can I reduce (101.25) to only what's *right* of decimal? (25)
Is there a function or a series of steps to accomplish this within an excel
spreadsheet?
|