Whole Fraction
 

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

Whole Fraction
 

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

Whole Fraction
 

I would like it to show 1/1 or 2/4or 4/4 ....whatever the fraction truly is


"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

Whole Fraction
 

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

Whole Fraction
 

Sorry Nick,
The formula works fine, its my data that's exported
from Access. The reason its showing with no numerator is because there isn't
one....duh! I'll change my export to show zero's.

Thanks!

"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

Whole Fraction
 

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