Mark,
If it has a 0, it displays correctly 0/4.
You mean if there is no value set ? i.e. blank.

In this case, it would be best to initialise all the table values to zero,
as this is the correct starting value for all.
A blank would mean "unknown" and showing 0/4 for an unknown would not
necessarily be correct.

NickHK

"MWH" wrote in message
...
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