Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Help with formula (Excel 97)

    I am trying to add "flexi" in addition to TOIL in the formula below. After much trial and error I am still having no success. Help!

    =IF(OR(H20="TOIL" ............. ), H9+H12+H15+H18, H9+H12+H15+H18+H21)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    Kerry

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with formula (Excel 97)

    Hi Kerry,

    How about
    =IF(OR(H20="TOIL", H20="flexi"), H9+H12+H15+H18, H9+H12+H15+H18+H21,)

    Do you need an expression if the OR returns False? Otherwise, a logical FALSE value will be returned by the function. You could use "" to return nothing if required.

    Alan

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Help with formula (Excel 97)

    Hi,
    Do you mean something like:
    =H9+H12+H15+H18+if(or(H20="TOIL,H20="flexi"),0,H21 ) ?
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Help with formula (Excel 97)

    Thanks Alan

    (H20="TOIL", H20="flexi") does the trick.

    Kerry

Posting Permissions

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