Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show fraction as fraction even if answer is 1 | Charts and Charting in Excel | |||
how to add 3/4 as a fraction | Excel Discussion (Misc queries) | |||
fraction of itself | Excel Discussion (Misc queries) | |||
Text fraction to fraction format | Excel Worksheet Functions | |||
How do I change fraction to fraction characters? | Excel Worksheet Functions |