I want to perform a simple percentage calculation using two columns, but only
perform the calculation if a page field is equal to "Y". If the page field
is not "Y" I want the formula to return a blank. Where the data columns are
2005-21 and 2005-22 and the page field is 0522COV. My formula is:
=IF('0522COV'="Y",(('2005-22'-'2005-21')/'2005-21'),"")
My formula returns the #Value! error. Can logical functions be used in
Pivot calculations?
--
Thanks for your help
Mike G.
Bookmarks