View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sjl sjl is offline
external usenet poster
 
Posts: 8
Default pivot table calculated field

Can I use an if statement in a caclulated field formula? I'm having a
problem with spending/target returning nothing if target is null. I have
another calculated field that is spendbud/budget and want to determine the
difference between the two, but am getting null if either target or budget is
null.

Thanks in advance!