| 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 |
| 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 | |||
Threaded Mode
