Forum Discussion
Average numbers that are entered as <
I have an excel spreadsheet that I enter lab results for the months of the year. Most results come back from the lab as example: < 2.8 In my spreadsheet I enter the numbers like this for the month....
If your data is in cells A1:A6, then the formula is:
=AVERAGE(VALUE(SUBSTITUTE(A1:A6,"<","")))
dscheikey thank you so much got the correct result. Only thing I need the answer to show that it's <
I do not understand exactly. A query whether the character "<" is present in the cell is achieved with the following formula. If TRUE, then the character is present. Otherwise FALSE.
=ISNUMBER(FIND(">",A1))