If( ) function in Excel

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

КОМЕНТАРІ • 46

  • @Aimandanialsyafiq
    @Aimandanialsyafiq 11 років тому

    Ur the best teacher ever! Clear speaking and very understandable.
    Btw my igcse for ict prac is 2morrow. Wish me luck everybody.

  • @areebakaleem6662
    @areebakaleem6662 6 років тому

    Thank you so much! I've got my exam tomorrow and i was totally freaking out. This helped me alot.

  • @vasquezfive805
    @vasquezfive805 10 років тому +1

    Great video!! thank you... did you have one with Multiple conditions formulas?

  • @primojadulcojr.1283
    @primojadulcojr.1283 10 років тому +1

    Now I learned a lot thanks... need more video about excel formulas

  • @dahaze140
    @dahaze140 8 років тому

    VEry practical learning skills you possess... nice 1 me like!

  • @poochiniosos1
    @poochiniosos1 10 років тому +2

    Can the test or condition itself be Y or No? For example if drop down box reads yes then cell A,1. If no then B1..

  • @hemchandra6563
    @hemchandra6563 8 років тому

    it was very effective and properly explained....thank you

  • @wadia005
    @wadia005 6 років тому

    Thank you so much! Helpful and very clear!

  • @quantumlolliepop5472
    @quantumlolliepop5472 8 років тому +2

    Is there a way to have multiple conditions in a single if command? For example, am I able to have the exact same thing as this video but have it say "200" as the bonus if they have over 900 sales? If so, how?

    • @icarus106
      @icarus106 7 років тому

      You can test multiple conditions by doing: =if(AND(condition1, condition2), value if true, value if false)
      You can give multiple outcomes by using a nested if like this: =if(sales>900, 200, if(sales>700, 100, 0) )

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

    in a given years list how to find leap year and ordinary year and divide leap year with 365 and ordinary year with 355 in excel? can you help

  • @shaikferoz6299
    @shaikferoz6299 8 років тому

    Thank you, Madam for your explanation it was quit clear

  • @SaifullahRaman
    @SaifullahRaman 12 років тому

    THANKS A MILLION! YOU SAVE MY LIFE!!!! GOD BLESS U!

  • @simtholemajula7063
    @simtholemajula7063 10 років тому

    Thanks a lot, more videos please!

  • @raghunandhanag239
    @raghunandhanag239 11 років тому

    Thank You....
    Nice Explanation Dear...

  • @TheBoss-ey1li
    @TheBoss-ey1li 9 років тому

    Can u please be my teacher i got exam tomorrow and I did half of it today and the if function I tomorrow u made my night less stressful

  • @nanokd
    @nanokd 11 років тому

    Thanks so much! This was very helpful! Keep on keeping on :) God Bless

  • @saaneroa5024
    @saaneroa5024 9 років тому

    Really helpful tutorial.

  • @poonamkaushik3574
    @poonamkaushik3574 7 років тому

    thanks madam you explained it so well

  • @adnanmohamedhashi5520
    @adnanmohamedhashi5520 8 років тому

    hey! thank you so much for the help me so quick bro but there is one problem still i didn't trying a lot of practice man soon insha'allah i will try lol

  • @tinygreen2110
    @tinygreen2110 6 років тому

    easy and useful , thank youuuu

  • @mohamedardy
    @mohamedardy 7 років тому

    i think it is most lovely explain for if statment especial writing beyond vido

  • @Neem0Mar
    @Neem0Mar 8 років тому +1

    That was clear. Thanks !

  • @sophuanchhoen3253
    @sophuanchhoen3253 11 років тому

    Thank you for your Video

  • @ivancatuday9296
    @ivancatuday9296 9 років тому +1

    Thank you so much :)

  • @stephaniepanko9707
    @stephaniepanko9707 11 років тому

    thank you, thank you, thank you!

  • @femtecent
    @femtecent 11 років тому

    I like your accent.

  • @hdkeemii8315
    @hdkeemii8315 6 років тому

    u blacked off the sides of the screen and expect us to see the sides when you say something ?

  • @hidgik
    @hidgik 6 років тому

    The way you say "sales" is almost the same as when you say "cells".

  • @hamizansharul
    @hamizansharul 13 років тому

    ty alot!

  • @Khonic23
    @Khonic23 7 років тому

    Understand that some people must utilize their time wisely, and rambling about off tangents is discouraging many viewers from watching as this video could have been shortened to 3 minutes.

  • @jorgeortega7031
    @jorgeortega7031 12 років тому

    EXCELENT THANKS A LOT

  • @hanisaeed1904
    @hanisaeed1904 8 років тому +4

    talk too much but useful

  • @fdgg3243
    @fdgg3243 7 років тому

    Thank you 💗💗💗💗

  • @WassupFred
    @WassupFred 8 років тому

    thank you so much

  • @hemantbhawsar8928
    @hemantbhawsar8928 6 років тому

    Why do not purchase a good quality camera

  • @nuwanpriyankara
    @nuwanpriyankara 10 років тому

    Yes thnxx

  • @singhsaravjeet5955
    @singhsaravjeet5955 9 років тому

    thankuuuuuuuuuuuu sooooooooooooooooo muchhhhhhhhhhhhhhhhhh

  • @camailacamcamjohnson1636
    @camailacamcamjohnson1636 7 років тому

    yes it was understanding

  • @siddharthnair9461
    @siddharthnair9461 7 років тому

    helpful

  • @KathyVanPelt
    @KathyVanPelt 12 років тому

    Thanks for your great video!
    Kathy
    2educateyou

  • @deniseroey8633
    @deniseroey8633 8 років тому

    She talks to much and doesn't do enough work.

  • @Cludo_
    @Cludo_ 12 років тому

    EXCELlent?

  • @learnsolo2721
    @learnsolo2721 6 років тому

    helpful