I have the following spreadsheet. I created an average column which needs to calculate an average on the following conditions:
-Numbers are computed in average
-Values beginning with an "<" are divided by 2, then computed in average
-Cells containing "--" are not counted in average
How can I get the average while ignoring the "--" cells? This is how I have it set up now:
{=AVERAGE(IF(ISNUMBER(B4:G4),B4:G4,VALUE(RIGHT(B4:G4,LEN(B4:G4)-2))/2))}
Any suggestions or help on how to make this formula work?
Capture.PNG
Bookmarks