Fill in D2 and copy down
![]()
=IF(AND(B2<7,OR(B2="M",B2="E",B2="C")),A2*14,0) + IF(AND(B2>7,OR(B2="M",B2="E",B2="C")),A2*10,0)+ IF(AND(A2>30,B2<>""),A2*10,0)
Fill in D2 and copy down
![]()
=IF(AND(B2<7,OR(B2="M",B2="E",B2="C")),A2*14,0) + IF(AND(B2>7,OR(B2="M",B2="E",B2="C")),A2*10,0)+ IF(AND(A2>30,B2<>""),A2*10,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks