Nick,
Your formula works great....except if the fraction has a 0 in the
numerator it is displayed (example) /4 instead of 0/4




"NickHK" wrote in message
...
Mark,

=IF(U1_Scorecard!C3=0,"", U1_Scorecard!E3*-1 & "/" & U1_Scorecard!C3)
Also, if you treat it as a fraction, 2/4 will appear as 1/2, which is not
what you (quite) mean.

NickHK

"MWH" wrote in message
...
Is it possible to display a whole number as a fraction?
(I have the cells formatted for fraction)

Here is a sample of a formula on my worksheet:

=IF(U1_Scorecard!C3=0,"", U1_Scorecard!E3*-1/U1_Scorecard!C3)

Cell C3 = 1
Cell E3 = 1

I would like to display 1/1, instead my result is 1
--
Mark W. Hanford