Excel Q

akanska · October 13, 2009, 4:18pm

I’ve built a heatmap the pulls in values from a pivot tabl(GETPIVOTDATA=…)and I need to have the cells that return “0” to show N/A but don’t know how. I though maybe I could use an if statement, but since I need the formula to return the value I don’t know how. any suggestions?

soddy1979 · October 13, 2009, 4:27pm

Would this type of IF statement work? I haven’t plugged it so I don’t know. =IF(GETPIVOTDATA=…=0,“N/A”,GETPIVOTDATA=…)

akanska · October 13, 2009, 4:37pm

soddy1979- that worked perfect- thanks!

JOE2010 · October 13, 2009, 4:45pm

Btw, akanska did you find the Excel 2007 book useful, if at all you used it?

eire1130 · October 13, 2009, 5:05pm

soddy1979 Wrote: ------------------------------------------------------- > Would this type of IF statement work? I haven’t > plugged it so I don’t know. > > =IF(GETPIVOTDATA=…=0,“N/A”,GETPIVOTDATA=…) if you want excel to recognize it as an error later you can use the […], NA(), […] instead of the “N/A”

system · October 13, 2009, 5:30pm

I think we should have a sticky Excel Q&A discussion going.