IF AND Logical Excel Formula - A Must Known and Very Useful Excel Formula in Tamil

Поділитися
Вставка
  • Опубліковано 30 жов 2024

КОМЕНТАРІ • 31

  • @ranjithrash5329
    @ranjithrash5329 3 роки тому

    Eventhough I watched this video already but it is helping me for my real time working with my current requirement. So I watch your posted videos daily yo upgrade my knowledge.

  • @melvinsanthanarajs4391
    @melvinsanthanarajs4391 4 роки тому +1

    Nice. Thank u sir

  • @thangarajkeyboard
    @thangarajkeyboard 5 років тому +1

    Tq Sir..

  • @kroobanraj2299
    @kroobanraj2299 5 років тому +2

    நன்றி

  • @HariKumar-ru9no
    @HariKumar-ru9no 3 роки тому +1

    Sir,
    U using if & and formulae for solution. Can we able to get solution by Nested if without using and formulae. Pls send your as "yes" or "No". After that kindly explain sir..

    • @Prabasmsoffice
      @Prabasmsoffice  3 роки тому

      Yes, but using AND along with IF formula makes our work easy.

  • @vijayalakshmib5923
    @vijayalakshmib5923 4 роки тому +2

    Thank you Sir, how to arrive condition if 5 to 10 sales then Rs: 300, if it is more than 10 Rs700. thereafter for every 5 Rs.400. Maximum: Rs.50000.

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      It is easy sister, I will try to explain this in a short video.

    • @rjgracefullyblessings8014
      @rjgracefullyblessings8014 2 роки тому

      Intha sister ketta question ku video iruntha share pannunga brother

    • @Prabasmsoffice
      @Prabasmsoffice  2 роки тому

      Sorry, I forgot to address this question, will try to cover it quickly.

    • @rjgracefullyblessings8014
      @rjgracefullyblessings8014 2 роки тому

      Ok brother

    • @Prabasmsoffice
      @Prabasmsoffice  2 роки тому +1

      You have to use multiple conditions to solve this requirement. Say hi to prabas@prabastech.com, i will try to share the output with you.

  • @prasannaprit6608
    @prasannaprit6608 4 роки тому +1

    Hi, Bro Averageif and Averageifs pathi detaila videos poduga bro.

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому +1

      Sure brother கட்டாயமாக ஒரு வீடியோ போடுகிறேன். நன்றி...

    • @prasannaprit6608
      @prasannaprit6608 4 роки тому

      @@Prabasmsoffice thk you I,m waiting bro

  • @subramaniamramamurthy7548
    @subramaniamramamurthy7548 4 роки тому

    Very much essential formula, thanks. Let me work out and if necessary I will let you know

  • @ganeshm8512
    @ganeshm8512 4 роки тому

    =2.5 wrong >2.5 is correct.

  • @tharunkumar1958
    @tharunkumar1958 5 років тому +1

    Nice Video Sir..
    Kindly upload practice file in your website prabastech.in
    Thanks in Advance.

  • @mmadhan4730
    @mmadhan4730 3 роки тому +1

    How I can sent query let me know please

    • @Prabasmsoffice
      @Prabasmsoffice  3 роки тому

      1. UA-cam Comments
      2. Email to prabas@prabastech.com
      3. WhatsApp to 9940261814

  • @dhivyad7556
    @dhivyad7556 5 років тому

    Bro... A column la 12345 nu oru id entry pandre... B column la 30.07.2018 nu oru date mention agum... Next 2nd row la... Customer id - date differents ah three date display agum.... Enaku single date separate ah multi date separate ah kedaikanum.... Blanks ah eduthukama...

  • @DEVARAJ-bg2zb
    @DEVARAJ-bg2zb 5 років тому +1

    Sir, ( choose & or ) vachi if condition la formula use pananum sir .

  • @babuvijaykumar883
    @babuvijaykumar883 5 років тому +1

    Hi bro I am working in abroad, one person is working in 9 hours working, athukum mela work pna athu OT so how to preparing the formula

  • @babuvijaykumar883
    @babuvijaykumar883 5 років тому +1

    Itha video la avarukum 2.5 mela irutha MF varanum, but enaku. 9 hours mela ieutha athu thaniya Total venum