Hi all.
I am referencing cells taken from a pivot table. So for example, cell A2 will have a value of 100 (in the pivot table) and cell B2 will have the formula =(A2). So B2 will always return whatever value is in cell A2.
I am looking for a formula that will return #NA for a referenced cell that is blank or has 0.
Can anyone help?
Thanks,
Bookmarks