View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Fractional formatting

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!!!! :(