I am using Excel 2010 on a Win7 PC.  I created a pivot table based on a fairly small data set, combination of text, formulas, percentages, numbers, etc.).  In the pivot table, the values from the source sheet that are derived from If/Then formulas show up in the pivot table as #Div/0!, but the value in the source sheet shows up as 50%.  The 50% (or other percentage value) is a result of the following formula:  =IF(O2=5,”0%”,IF(O2=4,”20%”,IF(O2=3,”40%”,IF(O2=2,”60%”,IF(O2=1,”80%”,IF(O2=0,”100%”)))))).  In other words, I’m assigning a % value based on a numerical ranking from 0 to 5.  However, the Pivot table does not recognize the formula-derived value.  If I just hard key “50%” into the source sheet cell, I have no problem seeing it show up in the pivot table.  Thanks for any help you can offer.

Edit your submission

Leave a Reply

Your email address will not be published. Required fields are marked *