memo
sample.txt
cat sample.txt
#################
Alice 25 27 50
Bob 35 37 75
Caren 75 78 80
David 99 88 76
awk '{ avg=($2+$3+$4)/3; if (avg>=80 && avg<90) result="A"; else if (avg>=60 && avg<80) result="B"; else if (avg>=50 && avg<60) result="C"; else if (avg<50) result="FAIL"; else result="Other"; print $0,":",result; }' sample.txt
awk '{
avg = ($2+$3+$4)/3;
if ( avg >= 80 && avg < 90 ) result="A";
else if ( avg >= 60 && avg < 80) result ="B";
else if (avg < 50) result ="FAIL";
else result ="Other"
print $0,":",result;
}'