Tento článek popisuje fungování funkce KDYŽ / IF. Jedná se o logickou funkci, která vrací buď jednu nebo druhou hodnotu podle toho, jestli je splněna určitá podmínka.

Její nejzákladnější fungování si ukážeme na příkladu, kdy v tabulce chceme rozlišit kladná nebo záporná čísla - ve sloupci B tedy chceme vidět slovo "kladné" nebo "záporné".

Do buňky B2 zapíšeme (a pak roztáhneme) tento vzorec:
  • =KDYŽ(A2>0;"kladné";"záporné")

Protože:

  • KDYŽ je název funkce
  • A2>0 je určité tvrzení. To je pro některé buňky pravdivé (např. A2, A4, A7) a pro jiné nepravdivé (A3, A5, A6).
  • "kladné" se má vypsat, pokud tvrzení pravdivé je
  • "záporné" se má vypsat, pokud tvrzení pravdivé není

(Ano, máte pravdu - neošetřili jsme možnost, že by číslo bylo přesně nula. Pro to bychom potřebovali, aby funkce KDYŽ produkovala ne dvě, ale tři nebo více možností. O tom je tento článek).

Poznámky:

Videonávod

13 Comments

  1. Bebe A Faim : 85 Recettes Et Conseils Sur L Alimen…
    Mild sleeping tablets Zopiclone provide the most long-lasting effect, but are capable of causing drowsiness the next day.
    Vision courtesy ABC News 24.

    www

  2. Absolutely NEW update of SEO/SMM package „XRumer 16.0 + XEvil 3.0“:
    captcha regignizing of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
    and more than 8400 another size-types of captchas,
    with highest precision (80..100%) and highest speed (100 img per second).
    You can connect XEvil 3.0 to all most popular SEO/SMM software: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.

    Interested? You can find a lot of introducing videos about XEvil in YouTube.
    Good luck 😉

  3. Hey,
    Normally I don’t regularly comment on blogs but, I’ve actually tracked down a website for us to view REAL celebrity gossip. On this site is what channels secretly use for public polls. Just read about it here on this share about Lotte Verbeek.
    -Give me your feedback after
    ReriuhErebsique

  4. Most Innovative Binary Option Broker!
    Totally free demo account;
    Trading simplified;
    No spreads and no commissions;
    24/7 trading on turbo and binary options.
    No credit card, no phone number required.
    Easy to start investing.
    Start trading binary options!
    http://commodities.deadline.mobi

  5. Skyrim Jagged Crown Quest. (браузерная игра ) After you unlock Leon’s unique costume, total Chapter 1-3 . skyrim требования http://skyrim2great15.iwillhost.com/skyrim-svyatilisha.php – skyrim2great15.iwillhost.com The Elder Scrolls V : Skyrim – Dawnguard (Bethesda Softworks) Бесплатная The Elder Scrolls V : Skyrim – Dawn Guard игра торрент на PC.

  6. robert smoley
    In enterprise enterprise world happen to be many venues in which speculation is regularly exhibited. Let’s clarify just what meant a new „speculator.“ This really is a businessman who is willing to take sizable risks in order to realize great monetary gains. Two prominent markets for common are commodity futures trading and foreign currency trading. The latter is commonly known as Forex trading.

    Age is considered as the base criteria for classification using the investment system. It is generally felt that low age yields maximum risk factors owing to less experience, whereas high age yields less risk, because one is more veteran.

    With Honest Forex Signals you are supplied daily email and SMS signals. Have got access to their live trading room during both the London and New York sessions. As well as you get a EA trade copier software to exercise on your Mt4 platform.

    Aside from silver, and gold coin business this has started to learn the attention of top big investors. It is because of the same reason that Numis Marketing had popped the probability of offering the primary opportunity due to its own investors to hold on to: their 100% Autoship after Five years. This means that in beating the general notion that in precious metals network marketing, soon-to-be investors will acquire more options to protect that their investment is secured. Price sure their hard earned money from silver and gold coins through MLM are secured to be diverted to your financial market and at the same time, can be placed and offered back to Numis had been 5 year period around the date of purchase.

    If you’re selling gold through a mail-in service, do research on them and their policies before do now. Find out it is far more will receive your payment, and never send your package without insuring it first.

    Make your expense list as detailed and accurate as just as possible. Save your food receipts. Check them for non-food items and add those under their correct row, like paper goods, dog food, laundry appliances. Figure out how much everyone spend on food.

    He was naturally nervous about confronting his parent. Although he was now a grown man, he the long childhood history obeying his aunt. He certainly did not for you to hurt his mother’s feelings or cause dissension in the family.

    There furthermore a new course made to teach you take advantage of a unique opportunities. The course was generated by a famous real estate investor, Charrissa Cawley. It will probably teach you everything you’ll need to develop into a successful property investor in only a not much time!

  7. tarot lame 8 tirage carte gratuit tarot signification tarot
    egyptien femme actuelle tarot belline gratuit amour tirage tarot marseille association carte
    tarot marseille signification voyance tarot gratuite en ligne meilleur site tarot divinatoire gratuit tirage tarot gratuit serieux
    en ligne marie claire astro tarot amour ange gardien tarot gratuit tarot journalier gratuit tarot ancien a vendre tarot 3 mois tarot amour gratuit cartomancie tirage tarot divinatoire gratuit persan tarot voir tarot le soleil a l’envers
    oracle tarot mai 2017 tarots en ligne gratuits carte tarot
    signification le fou tirage tarot du jour

  8. Hello pals
    I say i’m sorry if I write off-topic
    But I some time ago had to find a detailed report about the best way to create essays for any university.
    I just located a great article. Perhaps someone else will will need this information.
    http://www.dmsysbg.com/writing-assignments-with-essay-services-is-simple/

    Incidentally, while I was interested in this short article, I discovered that lots of people obtain home functions, compositions, papers and essays. I don’t know how protected it is and what quality may be obtained within the finish. Who faced this predicament, write, you create or obtain? Have been you caught by tutor for this?

Napsat komentář

Vaše emailová adresa nebude publikována.

*

smazat formulářOdeslat komentář