Zomi.Net Your Network, Empowered by YOU!
Excel - Nested Formula Dotna
Gtn:
Column A aom number pen 1000 pan 1999 ciang ahihleh "Cing Khup", tua kikal ahihkeileh "Ngam Bawm".
Column A aom number pen 2000 pan 2999 ciang ahihleh "Peng Lam", tua kikal ahihkeileh "Hang Sai".
=IF(AND(A1>=1000,A1<=1999),"Cing Khup","Ngam Bawm")
=IF(AND(A1>=2000,A1<=2999),"Peng Lam","Hang Sai")
Hih formula nihpen khatin atkhawmleng akingah diam? Akingah leh bangci atdingcih atheite'n nonghilh nadingun ongcial ingei.
Lungdamkhol,
Column A aom number pen 1000 pan 1999 ciang ahihleh "Cing Khup", tua kikal ahihkeileh "Ngam Bawm".
Column A aom number pen 2000 pan 2999 ciang ahihleh "Peng Lam", tua kikal ahihkeileh "Hang Sai".
=IF(AND(A1>=1000,A1<=1999),"Cing Khup","Ngam Bawm")
=IF(AND(A1>=2000,A1<=2999),"Peng Lam","Hang Sai")
Hih formula nihpen khatin atkhawmleng akingah diam? Akingah leh bangci atdingcih atheite'n nonghilh nadingun ongcial ingei.
Lungdamkhol,
Comment
© 2024 Created by Zomi Community Network.
Powered by
You need to be a member of Zomi Community Network - Your Network to add comments!
Join Zomi Community Network - Your Network