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