| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Logical Function in Pivot Calculation
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A logical test in the If function for blank, i.e., If blank? | Excel Worksheet Functions | |||
| Pivot Table or Function?? | Excel Discussion (Misc queries) | |||
| SUMIF function in "Price quote with tax calculation" templae | Excel Worksheet Functions | |||
| Logical Function Question | Excel Worksheet Functions | |||
| using logical functions as criteria with the SUMIF function | Excel Worksheet Functions | |||
Linear Mode
