I've been using Microsoft Excel for years so one would think I could easily come up with this simple little IF formula -

=IF(ISTEXT(B10),"NA",IF(B10>AQ$9,"Abv CA Avg", IF B10=AQ$9,
"Eql CA Avg",IF B10 < AQ$9,"Blw CA Avg"))))

But ... the above formula took me over two hours to figure out and to get it to do what I wanted it to do. I hate when applications make me feel stupid.