| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not reduce fractions
I am trying to set up a depreciation schedule and I want the denominator of
fraction to stay a constant - do not round or reduce. For instance, if the months, cell I8, (the denominator) is 72, then the formula =IF(F13="","",((F$5-F12)/I$8)) would give the answer of 2/72, 3/72, 4/72, etc. But the denominator won't always be 72, it might be 150, etc. I have tried to format the cell to # ???/???, but Excel keeps reducing the fraction. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get excel to NOT auto reduce fractions. | Excel Discussion (Misc queries) | |||
| Reduce code | Excel Discussion (Misc queries) | |||
| How do I reduce fractions into lowest terms? | Excel Discussion (Misc queries) | |||
| Reduce subtotals all at once? | Excel Discussion (Misc queries) | |||
| Reduce # of pages | Excel Discussion (Misc queries) | |||
Threaded Mode
