Forum Discussion
Use a conditional value in a formula?
I need to create a formula to get the average of 11 discontiguous cells. If there's a negative value in one of those cells, though, it should be dropped. Is this possible? Can it be done without...
Why are those cells non-contiguous? Can you show us what your layout looks like? Or -even better- upload an anonymized copy of your workbook? (to upload files, click the reply link and then the "Open full text editor" link)