IF Logical Function in excel in Hindi
IF Logical Function in excel in Hindi - if() formula में AND() Logical Function का उपयोग कैसे करें || इस वीडियो में full explanation के साथ देखें | • IF AND Logical functio... MS Excel 2007 / 2013/ 2016 /2013 logical formula IF, AND in hindi - How to Use The IF Function in Excel.
This excellent tutorial has been created by a professional Excel tutor. It demonstrates how to use the IF Excel function in hindi
Hope you will like the video. Thanks for watching.
-------------------------------------------------------------------
-------------------------------------------------------------------
Subscribe to my channel:
/ deepakeduworld
-------------------------------------------------------------------
-------------------------------------------------------------------
like my facebook page:
/ deepakeduworld
-------------------------------------------------------------------
-------------------------------------------------------------------
my facebook profile:
/ nehra92
-------------------------------------------------------------------
-------------------------------------------------------------------
follow on linkedin:
/ deepakeduworld
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
_____________________________________________________________
MS WORD के videos के लिए ये playlist देखे
• 📰 MS Word 2010 Tutoria...
_____________________________________________________________
ADVANCED MS EXCEL के videos के लिए देखे ये playlists
• 📊 ADVANCED Excel
_____________________________________________________________
HTML5 & CSS3 के videos के लिए ये playlist देखे
• ⏹ HTML5 CSS3 Tutorial...
_____________________________________________________________
COMPUTER के TECHNICAL videos के लिए ये playlist देखे
• 📺 Computer Tips & Tricks
_____________________________________________________________
_____________________________________________________________
Пікірлер: 103
Bahut acha samjaya aapne thankyou
Sir bht achha padhate hai aap bilkul detail mein btaye hai thnx sir🧡🧡🧡
Sir aapka samjhane ka tarika bahot acha hai, pura samajh me aagya, thank you.
sir main excel mein new hun lekin aap ki video dekh kar bahut kuch sikha sir aapka samjhane ka tarika bahut hi achcha hai
Jabardast Deepak sir...aap Ka vidio dekhne Ka Maja kuch alag hi he..
Because you have good teaching method seriously...👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌
Thanks sir...
I don't have any doubt after watching your video thank a lot sir.
sir thank you very much. is Tara samjhana kelie
Thinks sir aap bhut accha smjate ho
Very nice.... Good explanation
Your videos are very helpful. In if formula I want to learn how to blink a cell if the quantity is at lower limit.
Very good sir g thank
Very nice..You people are great
super meri vai
Fantastic. Looking forward for more.
Amazing sir....... ❣️
Thanks deepak sir
Thank you bhai practical exam tha mera
Thanks Sir 👍
Thanks sir Mai kevel Aapki hi video dekhti hu
Thank you for teaching this formula in simply way Please teach me pivot table of advance level in simple way
Thank you so much
Thanks
@ansumangamerz3613
3 жыл бұрын
Thanks for likening
@ansumangamerz3613
3 жыл бұрын
Today our computer exam
Excellent sir 🙏🙏
Very nice sir
Thanks Bhai
bohut acha video, Dada look up ka v banana plz agar look up ka video hai than share plz the link
Great video 🥰🥳
thanx sir
Nice 👌🏻👍👍
👍
Thankq so much sir
@DeepakEduWorld
4 жыл бұрын
😊
Bhi ap ki agli vedio kasa milay GI. Plz plz reply . Thank You.
Very good make more videos on excel formulas sir
Sir Mai first time excel ka use kar Raha hu means learning because I m a student sir please make a video for ms Excel besic formula for bigginer thanks sir
exact
And or function ke bare mein btaiye🧡🧡🧡
.nice
Nice video
Marksheet me first 2nd 3rd division lagao
sir video k sath jo excel sheet aap use krte ho wo attach kr diya kro. practice k liye
Nice video.one thing is that when you written the farmula in Excel kindly closed up so we can see clearly hope that you will Thanks
Sir ek video freezing pe bhi banaiye....means $ ka use
@DeepakEduWorld
5 жыл бұрын
G
Sir aap ki aabaj bhut acchi h
How To Use IF Function In Time & Date Format, For Showing Greater Than & Less Than Conditions
@DeepakEduWorld
4 жыл бұрын
Normally put
Good sir
@DeepakEduWorld
4 жыл бұрын
😊
How to use if function when any student is absent in all exam or particular subject.
How can I join your excel classes want to learn from start or beginning. Please please please reply
Excellent
@osathireterebinabhikyajina8752
5 жыл бұрын
Sir Ek Problem Aaraha hai us problem ko dur karns chahatha hue Kya karu kirpaya Aap see contact karna chahatha hue
@priyarana9095
5 жыл бұрын
sir excel m all formulle h kitne pls tell me
How to calculate profetional tax genderwise
man lo kisi subject me student ke marks 25 hain or usko 8 no ka grace dena ho to wo to add ho raha hai but data me niche ke numbero me bhi 8 marks 8 ho rahe hai sir plz solve my problem
सर एक्सेल मे युटिलिटी सोफ्टवेयर बनाने का विडिओ बनाओ सरजी
Bhai attendence sheet mai koi mahina me 2 din absent hai to 2 jodna hai 3 or 3 se jayada absent hai 2 plus nahi hoga is ko solve kase kare iaska formula kya hai bhai please batao tum bahut accha teaching karte ho
@DeepakEduWorld
4 жыл бұрын
If or countif Formula ak sath use krne hone.. plz wait.. i ll publish a video shortly
Best video and very intelligent person made this 👍
How can I determine a cell if that is between the range in if formula? I mean those person who keep 50 -70% marks than he is semi skilled and those people who keep >80 is proficient and those people who keep
@DeepakEduWorld
6 жыл бұрын
Use if with and
There are five name having different title in different rows. Suppose Mohan Sah, Lalan Yadav, Ramesh Pandey, Mohan Choudhary, Ratan Paswan are such persons in differnt rows but in one column. They are EBC, BC, GEN, EBC and SC category respectively I know. I want to write category in front of such name in second column such as EBC in front of Mohan Sah, Bc in front of Lalan Yadav respectively. Is it possible? Make a video on this please .
Bhaee saab Monthwise Salary myn jan to Dec tak Formula kesay lagay ga matlab har month 31,30,29,ya 28 ka hota hay =if(c2="feb",d6/29*e6,) Ye pore saal ka kesay bane ga??
Hello bro
Sir l try if formula but fail l click then result is hex......pl.guid me
भाई मुझे एक जानकारी चाहिए जैसे मैं माल खरीदी करता हूँ और कोई माल 12 pcs में आता है कोई 6 में कोई 3 में कोई 2 pcs में आता है तो मुझे एक्सेल में ऐसा फार्मूला बताइए जिससे एक बार अमाउंट लिखने पर एक pcs का रेट जनरेट हो जाये
Hello sir. Sir hum sugar packing ka business karte hai.sugar ka 50kg ka bag hota jo hum 2 kg pkg karte he baad me 12kg ka 1 bundle banate hai means 2kg ke 6 packet toh sir ek 50kg ke bag me 4bundle or 1 packet 2 kg ka banta he .toh agar koi customer 50kg ke 100 bag pkg ke liye deta hai toh sir hamein use kitne bundle or kitne packet dene hoinge.if formula use kiya lekin answer points me aata he or exact pata nahi chalta ke kitne bundle or kitne packet dene hai.fir haath se hisab karna padta hai or jyada time lagta he toh sir isme konsa formula use hoga agar aap email id de toh me sheet sent karsakta hu.please sir isme kuch help kijiye
data provide kro for practice
Vai Opening and Closing Blance. Iska. Ek Video Do na Jaha. Closing Blance. khatam Horah he O Blance Next Day Opening Blan hoga. Eisa Ek Video Do pls
Deepak sir mujhe if formula lagana hai lekin nahi ho rahahai pls help karen. ek basic pay ka amount hai aur uska 35% NPA (non practicing allowance) dena hai lekin basicpay+NPA = 85000 se jada nahi hona chahiye. mujhe yah formula lagana hai ki agar NPA aur basic pay 85000 se less ya equal aalye to 35% aana chahiye aur jada hota hai to NPA itna aana chahiye ki Basic pay + NPA 85000 se jyada nahi chahiye
Hii If. 01:10 ho toh next columns m Show hoye OK..But if 01:15 aa 01:20 ,02:15. Etc ..tab likha aaye. Exceed... Plz solve this conditions...
=IF(RIGHT(E12,2)>=50,"hi",0) it not work E12 contain number10322 than number 22 shows result hi why it shows wrong resut? help
Sir Apki ye video Play hi nhi ho rhi hai
Sir epne ek cell ka krke bataya h agar all cell pe kare toh kaise karenge
@DeepakEduWorld
5 жыл бұрын
Uske like if ke sath AND function lagana padega.. Video ka links.. Is video ke description mai hai 👍👍
@sajalsharma4487
5 жыл бұрын
@@DeepakEduWorld okk sir thanks aur sir ek aur formula hai Future formula woh bhi batado
Sub fail kase dhkhe result me
Send me the attendance template
सर रिझल्ट शिट तयार करायचे आहे . आपण तीन विषयात मिळून एकूण 20 गुणांची ग्रेस देतो. त्या तीन विषयात प्रत्येकी जास्तीत जास्त 10 गुणाचीच ग्रेस आली पाहिजे. तरी रिझल्ट या कॉलम मध्ये pc,pass,fail साठी कोणता formula use करता येईल. कृपया मार्गदर्शन करावे .इयत्ता 9वी साठी.
hi can you solve my query 25 c 50 d 36 c 95 d if "c "aye to 25 me 100 plus ho jaye nahi to "d" aye co 36 "-" ho jaye
advance wala kaise nikalna hai
@DeepakEduWorld
4 жыл бұрын
Advanced Excel ki playlist dekho
aa
154 डिग्री + 325 डिग्री = 479 - 360 = 119 125 डिग्री + 204 डिग्री = 329 ok अगर में कोई भी अलग दो डिग्रियां को जोड़ता हू तब 360 डिग्री तक तो सही है पर जब 360 से ज्यादा हो तब उसमे से 360 अपने आप घटकर 360 के अन्दर की संख्या मुझे मिल जाए में IF फार्मूला का केसे इस्तेमाल करू
@kishankumar2488
4 жыл бұрын
Mai kal Office ja kar Try karta hu...
Sir 10000 से 30000 बिच 20%केसे निकाले
=IF(C14>=5000,80,IF(C14>=6000,150,IF(C14>=12000,200,0))) Not Work Meri Galati Kaha ho Rahi He Batake Margarshan De 5000 Se Uper 80 6000 Se Uper 150 12000 Se Uper 200 Muje Text Me Answer Nahi Munber me Chahiye
=IF($L$840,($L$8*12)+($L$8-40*6)) please can you explain what is wrong it give error #VALUE! I want to do if $40 than 12 pay and above $40 then balance Hour is $18 (if 55 hour then 40*12 and 15*18) please let me know Thanks
More than 20000 ko 1000 aur less than ko 500 . Kitni galat baat hai
@DeepakEduWorld
4 жыл бұрын
Logic smgho dear😊
YOUR SPELLING OF LABOUR IS WRONG
Very nice sir
@DeepakEduWorld
4 жыл бұрын
😊😊😊
Good sir
@DeepakEduWorld
4 жыл бұрын
😊