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,
--
Gary Beard

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

-----Original Message-----
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))+INDIRE CT
("'"&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,
--
Gary Beard


.

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,

--
Gary Beard

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

-----Original Message-----
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,

--
Gary Beard


.