jnix612
04-25-2018, 06:09 AM
I need some guidance. I am unable to determine if I need a formula for what I will describe below and which formula:
Give me the average of these 4 rows, unless the average is 0 (zero), if the average is 0 (zero) enter this text (“this text” is an adjacent row).
When I create a PivotTable, and if 0 is the result I will get a lot of questions about what does 0 indicate. I have 7 reasons why scores would be 0, and this type of data would be useful for analytics so I want it spelled out clearly.
I have attached sample in Excel.
Give me the average of these 4 rows, unless the average is 0 (zero), if the average is 0 (zero) enter this text (“this text” is an adjacent row).
When I create a PivotTable, and if 0 is the result I will get a lot of questions about what does 0 indicate. I have 7 reasons why scores would be 0, and this type of data would be useful for analytics so I want it spelled out clearly.
I have attached sample in Excel.