Excel Easy 1

Pages

▼

Showing posts with label indext match. Show all posts

Showing posts with label indext match. Show all posts

Tuesday, March 26, 2019

10. [Word Excel VBA] Dùng hàm If, Match, Index trong tính tiền điện

Cột H4: =IF(G4<=F4,G4*INDEX($C$16:$E$18,MATCH(F4,$C$16:$C$18,0),MATCH(RIGHT(B4,3),$D$15:$E$15,0)+1),F4*INDEX($C$16:$E$18,MATCH(F4,$C$1...

View web version

Powered by Blogger.