Nguyen Anh Dung
Board Regular
- Joined
- Feb 28, 2020
- Messages
- 180
- Office Version
- 2016
- Platform
- Windows
Hi All,
please help me formular for result in excel.
i have image as below. i want result as column F,G,H,I.
if E4= "Lớp G" then F4=1,G4=2,H4=3, I4=""
the same if E5=" Lớp H" then F5=4,G5=5,H5="", I5=""
the same if E6=" Lớp J" then F6=6,G6=7,H6=8, I6=9
Best regards,
Nguyen Anh Dung
please help me formular for result in excel.
i have image as below. i want result as column F,G,H,I.
if E4= "Lớp G" then F4=1,G4=2,H4=3, I4=""
the same if E5=" Lớp H" then F5=4,G5=5,H5="", I5=""
the same if E6=" Lớp J" then F6=6,G6=7,H6=8, I6=9
Best regards,
Nguyen Anh Dung