IF(G7>59,"2","1"ทุกคังที่พิมฟันชันเสริดให้ไส(3ตัว
=IF(G6>79,K2,IF(G6>69,"3", IF(G6>59,"2",IF(G6>45,"1","0"))))
=IF(G7>79,K2,IF(G7>69,"3", IF(G7>59,"2",IF(G7>45,"1","0"))))
=IF(G8>79,K2,IF(G8>69,"3", IF(G8>59,"2",IF(G8>45,"1","0"))))
=IF(G9>79,K2,IF(G9>69,"3", IF(G9>59,"2",IF(G9>45,"1","0"))))
=IF(G8>79,K2,IF(G8>69,"3", IF(G8>59,"2",IF(G8>45,"1","0"))))
=IF(G9>79,K2,IF(G9>69,"3", IF(G9>59,"2",IF(G9>45,"1","0"))))
เงินเดือนa+bรายได้เพิ่ม-dรายจ่าย
วิธีทำ=B5+B9+C9
วิธีทำ=B5+B9+C9
=B6+B10+C10
=B6+B11+C11
=B6+B12+C12
=B9+B13+C13
นำเงินเดือนb5+b9ค่า ot + c9ค้านายหน้า
วิธีทำ=B5+B9+C9
วิธีทำ=B5+B9+C9
=B6+B10+C10
=B6+B11+C11
=B6+B12+C12
=B9+B13+C13
นำยอดขายb8*c8คอมมิชชั่น+d8เงินเดือน
วิธีทำ=B8*C8+D8
=B9*C9+D9
=B10*C10+D10
=B11*C11+D11
=B12*C12+D12
=B13*C13+D13
=B14*C14+D14
=B15*C15+D15