Hey gang, looking for a little help again...

I'm looking for a cell to add 2 others cells together depending on the
number of another cell (confused yet...). Here's a breakdown...

I want cell D7 to show the answer. It needs to check cell C7 and compare it
too 3 different ranges (The ranges are a set of numbers). If C7 is found in
Range1, then it's needs to do A7-B7, if C7 is found it Range2, then it needs
to do B7-A7, and if it's found in Range3, it needs to do 0-(A7+B7). Here's
my formula so far:

=IF(C7=G2:G19,A7-B7,IF(C7=H2:H19,B7-A7,IF(C7=I2,0-(A7+B7))))

G2:G19 is Range1
H2:H19 is Range2
I2 is Range3

I keep getting "FALSE" as a return. What's wrong with this? Thanks for
your continued help.

Matt

maybe

=IF(NOT(ISERROR(MATCH(C7,G2:G19,0))),A7-B7,IF(NOT(ISERROR(MATCH(C7,H2:H19,0))),B7-A7,IF(C7=I2,-(A7+B7),"No matches")))


"mpenkala" wrote:

Hey gang, looking for a little help again...

I'm looking for a cell to add 2 others cells together depending on the
number of another cell (confused yet...). Here's a breakdown...

I want cell D7 to show the answer. It needs to check cell C7 and compare it
too 3 different ranges (The ranges are a set of numbers). If C7 is found in
Range1, then it's needs to do A7-B7, if C7 is found it Range2, then it needs
to do B7-A7, and if it's found in Range3, it needs to do 0-(A7+B7). Here's
my formula so far:

=IF(C7=G2:G19,A7-B7,IF(C7=H2:H19,B7-A7,IF(C7=I2,0-(A7+B7))))

G2:G19 is Range1
H2:H19 is Range2
I2 is Range3

I keep getting "FALSE" as a return. What's wrong with this? Thanks for
your continued help.

Matt

First off, you're getting FALSE because everything you wrote is going to be
an error or false no matter what. But it is FALSE because your last IF
statement doesn't have a FALSE statement to it. Try this...

=IF(MATCH(C7,G2:G19,0),A7-B7,IF(MATCH(C7,H2:H19,0),B7-A7,IF(C7=I2,0-(A7+B7),"No Match")))




"mpenkala" wrote:

Hey gang, looking for a little help again...

I'm looking for a cell to add 2 others cells together depending on the
number of another cell (confused yet...). Here's a breakdown...

I want cell D7 to show the answer. It needs to check cell C7 and compare it
too 3 different ranges (The ranges are a set of numbers). If C7 is found in
Range1, then it's needs to do A7-B7, if C7 is found it Range2, then it needs
to do B7-A7, and if it's found in Range3, it needs to do 0-(A7+B7). Here's
my formula so far:

=IF(C7=G2:G19,A7-B7,IF(C7=H2:H19,B7-A7,IF(C7=I2,0-(A7+B7))))

G2:G19 is Range1
H2:H19 is Range2
I2 is Range3

I keep getting "FALSE" as a return. What's wrong with this? Thanks for
your continued help.

Matt