Miss-wrote previous "IF" problem

[gbeard]

I originally stated that I needed a blank if the result was <=$B$3 but I
need a blank if it is >$B$3 not <. I need it to return the sum if it is
<=$B$3.

Here's what I'm working on:

=IF(INDIRECT("'"&B$1&"'!"&"C$2"&ROW(A2))+INDIRECT("'"&B$1&"'!"&"C$4"&ROW(A2))<=$B$3,(INDIRECT("'"&B$1&"'!"&C$2&ROW(A2))+INDIRECT("'"&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,

 

[Biff]

Hi!

Ragdyer is pretty sharp! He knows what he's talking about.

Did you follow his advice? Judging by the formula you have
posted here, it doesn't look like it.

Biff

 

[gbeard]

Biff,
Ragdyer's advise was based on information that I presented incorrectly. He
answered my question perfectly, but I asked the question incorrectly. His
answer gave me a blank for any response< my threshold. I meant to ask for a
formula that would return a blank for a > response not <. I basically
didn't need the final argument, which confused RD and hence everything gave
me the "" response.
What I need is my original final response to be the TRUE response, and a
blank to be the FALSE response.

Thanks,

 

[Biff]

Hi!

Then just swap arguments:

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

Biff