Entered in E2 tryand pull down as needed![]()
=IF(LEFT(B2,1)="3","",D2*(IF(C2<DATE(2012,11,14),VLOOKUP(LOOKUP(REPT("z",255),$A$2:A2),SinglePoints,2,0),VLOOKUP(LOOKUP(REPT("z",255),$A$2:A2),DoublePoints,2,0))))
Entered in E2 tryand pull down as needed![]()
=IF(LEFT(B2,1)="3","",D2*(IF(C2<DATE(2012,11,14),VLOOKUP(LOOKUP(REPT("z",255),$A$2:A2),SinglePoints,2,0),VLOOKUP(LOOKUP(REPT("z",255),$A$2:A2),DoublePoints,2,0))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks