Using IF then to average grades on 4 point scale

You're welcome, but give tigeravatar's second suggestion a try. I haven't tried it but being non-array it would be preferable.
Don't forget to mark your thread as SOLVED (see instructions in rule #9 by clicking Forum Rules @ top of page).