Results 1 to 3 of 3
  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    IF/OR Statement (Excel 2007)

    Its been a while since I had to use an IF/OR statement:
    I have a spreadsheet with a combo box Form Control. In the box I have 8 items. I need to add a formula in the next column over that will show a dollar amount, IF the cell link shows either 5 or 6. The if statement works just fine =IF($R3=5,$J16,"") what I forgot was how to write an IF/OR statement so that if either 5 or 6 shows then $J16.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IF/OR Statement (Excel 2007)

    <code>=IF(OR($R3=5,$R3=6),$J16,"")</code>

  3. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: IF/OR Statement (Excel 2007)

    Thanks Hans
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

Posting Permissions

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