Re: สูตรการ คำนวณเบี้ยขยัน
Posted: Thu Jan 30, 2020 11:11 pm
D18
=LOOKUP(COUNTIF(INDEX($C3:D3,MATCH(2,INDEX(1/($C3:D3<>1),))):D3,1),{0,2,4,6},{0,200,300,500})
=LOOKUP(COUNTIF(INDEX($C3:D3,MATCH(2,INDEX(1/($C3:D3<>1),))):D3,1),{0,2,4,6},{0,200,300,500})