Fractional formatting

[Jim]

why does a cell return a decimal when text is linked in an "if statement"????
... the format of the cell is set to fractional.

This statement """=IF(G4=0,"",G4&"'' x")""": retuns (a decimal): I.E .375"
x -----
What I need the cell to return is: 3/8" x

if I i re-write it too: =if(G4=0,"",G4): it returns a fraction. I.E 3/8

HELP!!!!

 

[Dave Peterson]

If I put:
=if(G4=0,"",G4)
in a cell that has a general format, then I see 0.375 (with =3/8 in G4 and G4
formatted as a fraction).

If I format that cell with the formula as a fraction, then I'll see a fraction.

But your formula is returning text, so the numberformat doesn't really apply.

You could use something like:
=IF(G4=0,"",TEXT(G4,"0/0")&"'' x")
or
=IF(G4=0,"",TEXT(G4,"0/0")&""" x")
(if you want double quotes instead of two apostrophes)

 

[Gord Dibben]

=IF(G4=0,"",TEXT(G4,"# ?/?" &" x"))


Gord Dibben MS Excel MVP