Would the "trust" issue you bring up come into play for the OP's
*particular* question? I mean, we are specifying the denominator to be the
value the numerator is being divided by, so wouldn't a cell format of
Fraction just give us back that numerator again? I would not think enough
precision could be lost in the decimal to underlying binary representation
to make a difference in the numerator value it the cell format calculates
given we have *fixed* the denominator to be the value the numerator was
divided by.

--
Rick (MVP - Excel)


"Bernd P" wrote in message
...
Hello Rick,

Your approach sounds reasonable but the OP mentioned a serious
application (depreciation schedule) and IMHO you cannot really trust
Excel's fractional number format. Please see entry 4 of my Excel
Don'ts:
http://sulprobil.com/html/excel_don_ts.html

I suggest to use the idea of your approach together with my UDF NRN:
http://sulprobil.com/html/nearest_rational_number.html

Regards,
Bernd