fractions in formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a custom number format (# ?/3) that seems to work just fine in all
worksheets except one particular formula. All number and formula use this
formatting.

The following formula displays the numerical vaues in decimal notation
instead of the custom fraction formatting of the cell? Does it have anything
to do with the displaying of text within the same cell? Can I get around it?

IF('Institution Entry'!L16>0,IF(F153="","Adjustment for Dev Hours =
"&F143&" ERN Hrs - "&H143&" DEV Hrs = "&(F143-H143)&" SEM Hrs","Adjustment
for Dev Hours = "&F153&" ERN Hrs - "&H153&" DEV Hrs = "&(F153-H153)&" SEM
Hrs"),"")

This is a typical result the result of the formula.

Adjustment for Dev Hours = 2.66666666666667 ERN Hrs - 2.66666666666667
DEV Hrs = 0 SEM Hrs

In this example, cells F143 and H143 both display 2 2/3. So why does the
formula convert to decimal?

I hope this is enough information to help.
 
Not sure but experiment with something like =TEXT(B5,"# ?/?")&" sem hrs"
best wishes
 
Back
Top