View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David127 David127 is offline
external usenet poster
 
Posts: 11
Default Pivot Calculated Field -If Statments

Hello,

I know 'If' statments can be used in Calculated Fields of pivot tables where
the result is a number. However is there a way the result can be text? e.g.
if(x.15,"Fail","Pass")

Thanks!