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

7 Comments

  1. Allow me to explain yet have wallet as well as Ethereum, you can come to the office to exchange with a touch screen phone (Android, iOS) and our experts will help you to easily install a portfolio. For any major purchase (> EUR500), we recommend that you use the Nano Ledger, a smart card that attaches into your computer or smartphone, and that protect very effectively your bitcoins (on sale at the House of the Bitcoin from EUR34. 80 TTC).
    After you save your data and created your account, your transaction will take only a few minutes.
    Commissions to our physical counter are:

    Pertaining to cash payments, the commission payment is fixed at 10%.
    For visa or mastercard payments, the commission is degressive in line with the accrued purchases:
    The minimal transaction is EUR20. Money, the maximum is EUR1, 000 per day and EUR6, 000 per month.
    The right way to sell bitcoins in our physical counter
    https://www.facebook.com/events/1956982364538644/
    On the same way, we’re going purchase your bitcoins for cash in minutes. You will need:
    The commission applied is the same as for credit card acquisitions.
    How to buy bitcoins online on our web site

    We invite you to register on the site Coinhouse in order to buy bitcoins and ethers online. VISA and Mastercard 3D Secure greeting card payments, prepaid cards types PCS and Neosurf ticket are allowed.
    Our commission payment on coinhouse. io is degressive in line with the accrued acquisitions

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

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

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

  5. Totally free demo account $1000.
    Easy to start investing!
    Innovative Trading;
    Easier than Forex!
    Best terms on the market!
    24\7 trading on turbo and binary options.
    Profit up to 90% per trade.
    Most Innovative Binary Option Broker!
    Trading simplified;
    Minimum deposit just 10$!
    Start trading right now!
    http://stocks.and.options.stiiick.pro

Napsat komentář

Vaše emailová adresa nebude publikována.

*

smazat formulářOdeslat komentář