View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Extract numerator from fraction

Hello,

I still suggest to take my NRN function.

The solution 10757/7897 for 1.362162855 has an absolute error of
8.34937E-09 while my function NRN(1.362162855,9999) would return
10505/7712 with an absolute error of just 8.07054E-09.

MOD(10505,7712) would give you the numerator.

Regards,
Bernd