IF(B4=AT3,"(=AVERAGE(U4,W4,AA4,AE4,AG4,AK4))")
The Blue part of your formula is wrong
This formula will work but you had only one condition, I added the second condition as a blank ""
=IF(B4="AT3",AVERAGE(U4,W4,AA4,AE4,AG4,AK4),"")
Excel would interprete AT3 as cell AT3 not course AT3. That's why that is in quotes
A sample workbook might help
Bookmarks