IF Function help

**Benny20** · 09-16-2009, 04:36 AM

Hi,

I have an IF function in which i am trying to put 2 different values in the [logical test] section of the forumla but do not know how to do this.

E.G

IF(D10="receive or rec back", B10+I10, B10-I10)

Am I able to put two variables in the logical test field?

Please advise

Many Thanks

**zbor** · 09-16-2009, 04:41 AM

You can use OR function

=B10+I10*IF(OR(D10="receive","rec back"),1,-1)

**Palmetto** · 09-16-2009, 07:36 AM

Original formula amended:
IF(OR(D10="receive",D10="rec back"), B10+I10, B10-I10)

ZBOR's formula with correction:
=B10+I10*IF(OR(D10="receive",D10="rec back"),1,-1)