IF Logical Function in excel in Hindi

Поделиться
HTML-код
  • Опубликовано: 7 сен 2024
  • 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

  • @ashurajput8925
    @ashurajput8925 2 года назад +1

    Bahut acha samjaya aapne thankyou

  • @techieshivansh3758
    @techieshivansh3758 2 года назад

    Sir bht achha padhate hai aap bilkul detail mein btaye hai thnx sir🧡🧡🧡

  • @tanishq1294
    @tanishq1294 2 года назад +1

    Thanks sir...

  • @gsincubatormaharashtra3967
    @gsincubatormaharashtra3967 3 года назад +1

    sir main excel mein new hun lekin aap ki video dekh kar bahut kuch sikha sir aapka samjhane ka tarika bahut hi achcha hai

  • @ansumangamerz3613
    @ansumangamerz3613 3 года назад +2

    Thanks

  • @angelsfashion845
    @angelsfashion845 3 года назад +1

    Best video and very intelligent person made this 👍

  • @Jasim25
    @Jasim25 3 года назад

    super meri vai

  • @vimalsahu8284
    @vimalsahu8284 3 года назад

    Very good sir g thank

  • @nehalsiddique9520
    @nehalsiddique9520 3 года назад +1

    Sir aapka samjhane ka tarika bahot acha hai, pura samajh me aagya, thank you.

  • @bijaytanty8434
    @bijaytanty8434 2 года назад

    Thanks Sir 👍

  • @RSona-ht3mi
    @RSona-ht3mi 2 года назад

    Nice 👌🏻👍👍

  • @kiransati3508
    @kiransati3508 4 года назад

    Because you have good teaching method seriously...👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌

  • @shitoryukarate5075
    @shitoryukarate5075 2 года назад

    I don't have any doubt after watching your video thank a lot sir.

  • @rohitkothari1217
    @rohitkothari1217 2 года назад

    Thank you so much

  • @aratikumari4385
    @aratikumari4385 4 года назад

    Thanks Bhai

  • @kanhucharanadas3948
    @kanhucharanadas3948 6 лет назад +1

    Jabardast Deepak sir...aap Ka vidio dekhne Ka Maja kuch alag hi he..

  • @maonojkumarkhilarmuna3748
    @maonojkumarkhilarmuna3748 6 лет назад +3

    sir thank you very much. is Tara samjhana kelie

  • @yashodanagpure1310
    @yashodanagpure1310 5 лет назад +1

    Very nice sir

  • @vijaymishra1008
    @vijaymishra1008 4 года назад

    Very nice..You people are great

  • @shibanichatterjee5622
    @shibanichatterjee5622 3 года назад

    bohut acha video, Dada look up ka v banana plz agar look up ka video hai than share plz the link

  • @poojatiwari6717
    @poojatiwari6717 5 лет назад +1

    Thinks sir aap bhut accha smjate ho

  • @kiransati3508
    @kiransati3508 4 года назад

    Thanks sir Mai kevel Aapki hi video dekhti hu

  • @swapanbhattacharya4155
    @swapanbhattacharya4155 2 года назад

    Fantastic. Looking forward for more.

  • @jitendernehra1350
    @jitendernehra1350 7 лет назад +1

    Very nice.... Good explanation

  • @satishbeniwal4625
    @satishbeniwal4625 3 года назад

    Great video 🥰🥳

  • @rumysasangeen3510
    @rumysasangeen3510 5 лет назад +1

    Thank you bhai practical exam tha mera

  • @nehadandona2568
    @nehadandona2568 4 года назад

    Excellent sir 🙏🙏

  • @rameshmaharana79
    @rameshmaharana79 3 года назад

    👍

  • @bright9900
    @bright9900 5 лет назад +1

    Thankq so much sir

  • @tehseenyasmine342
    @tehseenyasmine342 3 года назад

    Amazing sir....... ❣️

  • @sangitasadhukhan1591
    @sangitasadhukhan1591 4 года назад

    Thank you for teaching this formula in simply way
    Please teach me pivot table of advance level in simple way

  • @sandeepdimri8930
    @sandeepdimri8930 4 года назад

    Very good make more videos on excel formulas sir

  • @muhammadfarooqmoten5525
    @muhammadfarooqmoten5525 5 лет назад

    Your videos are very helpful. In if formula I want to learn how to blink a cell if the quantity is at lower limit.

  • @dipeshjangid7330
    @dipeshjangid7330 5 лет назад +1

    Thanks deepak sir

  • @AMITSINGH-wh7ng
    @AMITSINGH-wh7ng 5 лет назад +1

    Good sir

  • @AMITJAIN-vo7tm
    @AMITJAIN-vo7tm 2 года назад

    How to use if function when any student is absent in all exam or particular subject.

  • @aliyasingh2249
    @aliyasingh2249 6 лет назад +1

    thanx sir

  • @techieshivansh3758
    @techieshivansh3758 2 года назад

    And or function ke bare mein btaiye🧡🧡🧡

  • @sikhamohanty3535
    @sikhamohanty3535 5 лет назад +1

    .nice

  • @shubhamchouhan9005
    @shubhamchouhan9005 5 лет назад +1

    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

  • @chetnakumari2380
    @chetnakumari2380 5 лет назад

    Nice video

  • @imranomar207
    @imranomar207 3 года назад

    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

  • @talhafaraz662
    @talhafaraz662 4 года назад +4

    Bhi ap ki agli vedio kasa milay GI. Plz plz reply .
    Thank You.

  • @ashish19able
    @ashish19able 3 года назад +1

    Marksheet me first 2nd 3rd division lagao

  • @poojatiwari6717
    @poojatiwari6717 5 лет назад +1

    Sir aap ki aabaj bhut acchi h

  • @jibankumar1109
    @jibankumar1109 6 лет назад

    Excellent

    • @osathireterebinabhikyajina8752
      @osathireterebinabhikyajina8752 5 лет назад

      Sir Ek Problem Aaraha hai us problem ko dur karns chahatha hue Kya karu kirpaya Aap see contact karna chahatha hue

    • @priyarana9095
      @priyarana9095 5 лет назад

      sir excel m all formulle h kitne pls tell me

  • @ajmalshahtravelling7088
    @ajmalshahtravelling7088 6 лет назад +1

    exact

  • @kavijyala471
    @kavijyala471 5 лет назад +1

    Sir ek video freezing pe bhi banaiye....means $ ka use

  • @Paigham-E-Ahlesunnat
    @Paigham-E-Ahlesunnat 5 лет назад +3

    How To Use IF Function In Time & Date Format, For Showing Greater Than & Less Than Conditions

  • @arthpatel4316
    @arthpatel4316 4 года назад +1

    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

  • @shamsherkumarshamsherkumar5750
    @shamsherkumarshamsherkumar5750 2 года назад +1

    Hello bro

  • @shyambabu2135
    @shyambabu2135 6 лет назад +1

    sir video k sath jo excel sheet aap use krte ho wo attach kr diya kro. practice k liye

  • @theonegammingnepal7071
    @theonegammingnepal7071 4 года назад +1

    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
      @DeepakEduWorld  4 года назад

      If or countif Formula ak sath use krne hone.. plz wait.. i ll publish a video shortly

  • @chakshupalbhagat1204
    @chakshupalbhagat1204 2 года назад

    How to calculate profetional tax genderwise

  • @jnjitu717
    @jnjitu717 6 лет назад +1

    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

  • @RanSingh-cr4ze
    @RanSingh-cr4ze 4 года назад

    सर एक्सेल मे युटिलिटी सोफ्टवेयर बनाने का विडिओ बनाओ सरजी

  • @lokeshsharma3297
    @lokeshsharma3297 3 года назад +1

    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

  • @keharisinghsharma4872
    @keharisinghsharma4872 4 года назад

    Sir l try if formula but fail l click then result is hex......pl.guid me

  • @bandhanianil
    @bandhanianil 5 лет назад +1

    भाई मुझे एक जानकारी चाहिए जैसे मैं माल खरीदी करता हूँ और कोई माल 12 pcs में आता है कोई 6 में कोई 3 में कोई 2 pcs में आता है तो मुझे एक्सेल में ऐसा फार्मूला बताइए जिससे एक बार अमाउंट लिखने पर एक pcs का रेट जनरेट हो जाये

  • @daudsuleman5605
    @daudsuleman5605 3 года назад

    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??

  • @vishalrajput1287
    @vishalrajput1287 4 года назад

    How can I join your excel classes want to learn from start or beginning. Please please please reply

  • @trickysportsbesttricks7383
    @trickysportsbesttricks7383 5 лет назад

    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 .

  • @marketall
    @marketall 4 года назад

    =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

  • @69SUSHIL77
    @69SUSHIL77 4 года назад +2

    154 डिग्री + 325 डिग्री = 479 - 360 = 119
    125 डिग्री + 204 डिग्री = 329 ok
    अगर में कोई भी अलग दो डिग्रियां को जोड़ता हू तब 360 डिग्री तक तो सही है पर जब 360 से ज्यादा हो तब उसमे से 360 अपने आप घटकर 360 के अन्दर की संख्या मुझे मिल जाए में IF फार्मूला का केसे इस्तेमाल करू

  • @nilkanthbhangale8387
    @nilkanthbhangale8387 2 года назад

    सर रिझल्ट शिट तयार करायचे आहे . आपण तीन विषयात मिळून एकूण 20 गुणांची ग्रेस देतो. त्या तीन विषयात प्रत्येकी जास्तीत जास्त 10 गुणाचीच ग्रेस आली पाहिजे. तरी रिझल्ट या कॉलम मध्ये pc,pass,fail साठी कोणता formula use करता येईल. कृपया मार्गदर्शन करावे .इयत्ता 9वी साठी.

  • @arvithetraveller7484
    @arvithetraveller7484 3 года назад

    data provide kro for practice

  • @926MTube
    @926MTube 4 года назад

    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

  • @sunilchandel5212
    @sunilchandel5212 5 лет назад

    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...

  • @aashuyadav1687
    @aashuyadav1687 4 года назад

    Sub fail kase dhkhe result me

  • @sajalsharma4487
    @sajalsharma4487 5 лет назад +1

    Sir epne ek cell ka krke bataya h agar all cell pe kare toh kaise karenge

    • @DeepakEduWorld
      @DeepakEduWorld  5 лет назад

      Uske like if ke sath AND function lagana padega.. Video ka links.. Is video ke description mai hai 👍👍

    • @sajalsharma4487
      @sajalsharma4487 5 лет назад

      @@DeepakEduWorld okk sir thanks aur sir ek aur formula hai Future formula woh bhi batado

  • @bhaveshkumarpandya
    @bhaveshkumarpandya 3 года назад +1

    =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

  • @sumitkumar-re5pq
    @sumitkumar-re5pq 5 лет назад

    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

  • @shivdasbhandare7718
    @shivdasbhandare7718 6 лет назад

    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

  • @setibasulakhe4095
    @setibasulakhe4095 Год назад

    Send me the attendance template

  • @mdfaiz541
    @mdfaiz541 3 года назад

    Sir Apki ye video Play hi nhi ho rhi hai

  • @carcaremadison5165
    @carcaremadison5165 3 года назад

    =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

  • @AdityaKumar-qh9uo
    @AdityaKumar-qh9uo 4 года назад

    advance wala kaise nikalna hai

  • @ravinderkalyaniya921
    @ravinderkalyaniya921 6 лет назад

    Sir 10000 से 30000 बिच 20%केसे निकाले

  • @amittejgoyal9123
    @amittejgoyal9123 4 года назад +1

    More than 20000 ko 1000 aur less than ko 500 . Kitni galat baat hai

  • @ajmalshahtravelling7088
    @ajmalshahtravelling7088 6 лет назад

    aa

  • @abhishekmishra25
    @abhishekmishra25 4 года назад

    YOUR SPELLING OF LABOUR IS WRONG

  • @Rizwankhan-et5oq
    @Rizwankhan-et5oq 5 лет назад +1

    Very nice sir

  • @AMITSINGH-wh7ng
    @AMITSINGH-wh7ng 5 лет назад +1

    Good sir