I want the AVERAGE function to be able to include cells which also contain the "<" character.
At the same time, I want cells containing the "<" character to use 50% of the reference value for purposes of the average calculation. I have attached an example of the output I'm seeking.
I would like for the solution to be a formula or array I can put into the calcuation cell without the need for dummy cells or off-page conversions or calculations. I can do that, using a single formula is what I'm struggling with.
Bookmarks