You should construct your formula with simple cell references first, to make
sure your logic is correct, before you complicate the references and lose
track of exactly what you're trying to accomplish.

Your formula equates to something like this with test addresses:

=IF(A2+B2<=B3,A2+B2,)

Don't know why you're ending it without a final argument?

From what you're saying, I would think that you want something like this:

=IF(A2+B2<=B3,"",A2+B2)

Which would make your formula look something like this:

=IF(INDIRECT("'"&B$1&"'!"&"C$2"&ROW(A2))+INDIRECT( "'"&B$1&"'!"&"C$4"&ROW(A2)
)<=$B$3,"",INDIRECT("'"&B$1&"'!"&C$2&ROW(A2))+INDI RECT("'"&B$1&"'!"&C$4&ROW(
A2)))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"gbeard" wrote in message
...

=IF(INDIRECT("'"&B$1&"'!"&"C$2"&ROW(A2))+INDIRECT( "'"&B$1&"'!"&"C$4"&ROW(A2)
)<=$B$3,(INDIRECT("'"&B$1&"'!"&C$2&ROW(A2))+INDIRE CT("'"&B$1&"'!"&C$4&ROW(A2
))),)

I'm trying to get this IF to return a blank cell if the result is <=$b$3.
But, it's returning every result whether it's < or $B$3.
This is returning the price of 2 columns if the total price is less than
the
customer wants to pay. The INDIRECTS are pointing to cells with info from
the customer (how many parts they're purchasing, how soon they need them,
what they want to pay and also what area they are in). Based on the area
they are in another similar formula returns the vendors who offer parts
for
the price they want to pay and this formula is in the column next to the
vendor name and shows their price. But right now it's showing every
vendors
price, which I could just look on the data sheet to find that information.


Please let me know if you can help,
--
Gary Beard