I have a formula that averages letters(See formula 1). The letters are TRUE argument results of another formula(See formula 2). However, Formula 1 will only work if all of my letter arguments are "true". Most of my cells have a letter, however some do not and are blank or "" since that was my 'false' statement. Does anyone have a work around for this?
Formula 1
=CHAR(ROUND(AVERAGE(IF(ISTEXT(BB3:BB24),CODE(BB3:BB24),"")),0))
Formula 2
=IF(BB5>74%,"A",IF(AND(BB5>=45%,BB5<=74%),"B",IF(BB5<45%,"C","")))
Bookmarks