Pivot Table Formula - Add Cell from outside table
Posted on 2011-05-05
If i have a formula on a pivot table that calculates some results no problem.
I want to add an IF to the formula so that if a field is a value it uses the formula but if it's zero i need it to drop in a value from a cell outside the pivot table.
For example if i had the formula to work out the cost we are paying for advertising, the formula would be
= Cost * Number of Enquiries
If i have a seperately worked out (outside the pivot) cost for the Internet in Cell M4 can i use this in the formula? i.e.
=IF (Source <> "Internet", Cost * Number of Enquiries, Value in Cell M4)
Is this possible?