+ Reply to Thread
Results 1 to 3 of 3

IF Function

  1. #1
    Registered User
    Join Date
    09-28-2009
    Location
    Alberta Canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    IF Function

    Here is what I think it should look like

    =IF(B1,E1,=IF(B2,E2,=IF(B3,E3,"")))

    This formula is in cell A

    What I am trying to say is that if B1 is true use E1 but if it's false check to see if b2 is true and if it is use e2, if it is false check to see if b3 is true and if it is use e3 if it's false leave the cell blank

    B1, 2 and 3 are tied to option buttons. The user can select only one option button. Depending on what button he selects I want one of three values (E1, 2 or 3) returned to this one cell (A1).

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: =if formula help

    This has somehow ended up in the Tips and tutorials section of the forum. I'm sure a friendly mod will move it to the right forum soon.

    As to your formula, you need to drop the spurious = signs

    =IF(B1,E1,IF(B2,E2,IF(B3,E3,"")))

    depending on the content of B1, this should work now, unless you want to specify the B1 condition a bit more ...

    hth

  3. #3
    Registered User
    Join Date
    09-28-2009
    Location
    Alberta Canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: =if formula help

    I noticed it ended up in tips... not sure on that one.

    Thanks for the help, I just figured it out as you posted.

+ 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