I created formula in Pivottable but sometimes the result is #DIV/0 because is some cells the number is 0. How can I avoid that appears #DIV/0? I tried with IF(A1="";"";...) though in Pivottable doesn't work the IF.
I created formula in Pivottable but sometimes the result is #DIV/0 because is some cells the number is 0. How can I avoid that appears #DIV/0? I tried with IF(A1="";"";...) though in Pivottable doesn't work the IF.
Last edited by pansovic; 09-06-2011 at 05:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks