+ Reply to Thread
Results 1 to 3 of 3

Is there an equation in Excel to use multiple if then statements?

  1. #1
    Cody5
    Guest

    Is there an equation in Excel to use multiple if then statements?



  2. #2
    Niek Otten
    Guest

    Re: Is there an equation in Excel to use multiple if then statements?

    Please post your question in the body of your message, not just in the
    heading. Some systems cannot cope with "empty" messages.

    Look in HELP for AND and OR, or post more details of what kind or multiple
    if statement you need.

    --
    Kind regards,

    Niek Otten

    "Cody5" <Cody5@discussions.microsoft.com> wrote in message
    news:E9F7AF01-ABDB-4AD3-8C54-4D1766F3E633@microsoft.com...
    >




  3. #3
    JE McGimpsey
    Guest

    Re: Is there an equation in Excel to use multiple if then statements?

    what do you mean by "multiple if then statements"?

    You can nest them:

    =IF(condition1, true1, IF(condition2, true2, false2))


    you can have multiple if's sequentially:

    =IF(condition1, true1, false1) & IF(condition2, true2, false2)




    In article <E9F7AF01-ABDB-4AD3-8C54-4D1766F3E633@microsoft.com>,
    "Cody5" <Cody5@discussions.microsoft.com> wrote:

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1