fractions in formulas
 

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'!L160,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.

fractions in formulas
 

Not sure but experiment with something like =TEXT(B5,"# ?/?")&" sem hrs"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"JWH23" wrote in message
...
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'!L160,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.