This discussion is archived
1 Reply Latest reply: Jan 18, 2013 12:03 PM by jshoe RSS

#Error when missing values

jshoe Newbie
Currently Being Moderated
I know I have seen this before but cant remember the fix. We have columns A and B, then a variance column. Users dont want to suppress so sometimes there is #missing in both columns so the variance column is returning a #Error. I can change the suppression to make it - or 0 but then my totals are showing a #Error also. Isnt there a formula for this? Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points