IF FORMULAS KE SATH BAKI FORMULE KO KESE USE KYA JATA HAI IN EXCEL? YAHI SE AP SIKH PAOGE

DOSTO FOLLOW JARUR KARNA

Dosto Aj Ki Class Me  Apko Bataunga  Ki Kese If Ke Sath Baki Formulas Ka Use Kya Jata He ?

 Jese Ki Pahle Hi Apne Padha Tha Ki If Function Ka Use Kese Kya Jata He

If Function Me Phle Logical Value Dalni  Hoti He Phir Usme True Value Dalni Hoti He ( Matlab Yadi Logical Pe Khada Utre To Kya Ana Chahiye) , False Value (Matlab Otherwise)

To Chalte He Dosto Ab Ise Shuru Karte He Ki Kese Use Kare Baki Formula Ke Sath If Condition Ko

Yadi If Function Me Atomatic Seris Dalni He To ( Jese Ki Aap  Jese Hi Koi Text , Number Type Karo Automattic Koi Series A Jaye )

Text Ke Lye :-

                                  

1	Raja	18
2	Ajay	18
3	Sonu	20
4	Monu	20

Is Series Ki Jagah :-

                                  =If(Istext(D5),C4+1," ") Ye Fomula Laga Denge (Range Kya                          Dena He Ise Dhyan Me Rakhkar)

                   

Raja	12	2	Ok
Ajay	18	3	Ok
Sonu	20	4	Not Ok
Monu	20	5	Not Ok

      Is Table Me "Ye Ok Aur Not Ok" Jo Dya Hua He Isme Condition Lagi  Hui He Jese Hi Pahle Column Wale Number Ko Dusre Column Wale No Se Bhag Denge Agar Answer "6" Ke Barabar Ho To "Ok" Dikhayega Otherwise "Not Ok"  Chalo Formulas Dekh Lete He Iska

 Raja          12              2    If(E5/F5=6,"Ok","Not Ok")        

Ajay          18              3    If(E6/F6=6,"Ok","Not Ok")

Sonu         20              4    If(E7/F7=6,"Ok","Not Ok")

Monu        20              5    If(E8/F8=6,"Ok","Not Ok")

Dosto Ek Bar Is Table Ko Bhi Dekh Lo

Raja	12	2	24
Ajay	18	3	24
Sonu	20	4	0
Monu	20	5	0

Is Table Me Formulas Logical Me Dya To He Hi Par True Value Nae Par Bhi Ek Formula Hi Apply Ho Aur False Ane Par Bhi (Dosto Ye He Formula Ke Andar Formula Aur Formula Ke Bahar Formula Chaliye Dekhte He Formula Kya He

Raja          12              2    =If(E5/F5=6,6*4,F5*0)        

Ajay          18              3    =If(E6/F6=6,6*4,F6*0)

Sonu         20              4    =If(E7/F7=6,6*4,F7*0)

Monu        20              5    =If(E8/F8=6,6*4,F8*0)

To Ye Formula He Jiski Sahayta Se Formula Ke Upar Bhi Formula Laga Sakte Ho Doto Agar Apko Koi Dikkat Ati He To Mujhe Comment Karne Me Rply Karunga

 

DOSTO YE CLASS CONTINUE JOIN KARTE RAHO AUR SABHI KO YE FREE CLASS KE BARE ME BATAO TAKI SABHI  SIKH SAKE AUR KOI PROBLEM ATI HE TO MUJHE COMMENT JARUR KARNA  (PLS 🙏🙏SHARE KARNA AUR MUJHE FOLLOW JARUR KARNA )

APKA MERE PAGE PE ANE KE LYE DHANYAWAD 🙏🙏🙏🙏 

LINK :- ADVANCEBANO.BLOGSPOT.COM

BY-AAKASH