View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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?