I am trying to find an average formula on Excel 2003 which will only average the percentages between 50% and 100% for a row of percentages. ie I need to discount many of the outlier percentages which are either negative or over 100%.
I have tried Average (if (B2:AE2 ">0.5 and < 1") but just somes up value#
Can you help please
I have tried Average (if (B2:AE2 ">0.5 and < 1") but just somes up value#
Can you help please