# Thread: Help with formula (Excel 97)

1. ## 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. ## Re: Help with formula (Excel 97)

Hi Kerry,

=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. ## 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.

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