With no. of school days passed in E2, remaining school days in F2 and how many more days attendance required to achieve in G2:
F3=($E$2*E3+$F$2)/190, copy down.
G3=IF($G$2*190-$E$2*E3>$F$2,"Impossible to achieve",$G$2*190-$E$2*E3), copy down.
With no. of school days passed in E2, remaining school days in F2 and how many more days attendance required to achieve in G2:
F3=($E$2*E3+$F$2)/190, copy down.
G3=IF($G$2*190-$E$2*E3>$F$2,"Impossible to achieve",$G$2*190-$E$2*E3), copy down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks