Return Of Excel

As my title suggests, The Beaver is back with a new Excel mini lesson again. These time I had to make a table. Here are the formulas that I used:

to calculate the interpose I used the same formula only with changed data:
in order to calculate if the student passed or failed use:
F5-> =IF(AVERAGE(B5,E5)<5, "failed", "passed").
That's all for today. Look at the image above.

Niciun comentariu:

Trimiteți un comentariu