if statements
I nee to have it be true if any of A18 thru A32 are a match.
Thanks,
Dianne
"Gary''s Student" wrote:
Hi Dianne:
Do you want True to mean ANY of A18 thru A32 matching D3, or do you mean
that ALL of D18 thru A32 matches D3??
--
Gary''s Student - gsnu200908
"Dianne" wrote:
Can anyone help me with the following I am getting a value error from this
statement
=IF(A18:A32=D3),"eff","not eff"
On worksheet Sheet2 there is a data table in range A17 J32 showing a
rate table and starting effective dates from top to bottom in column A. The
rate in each row is effective for the date found on the left and effective
until a new row and date are entered below that row. Example: The rates in
row 20 are effective from 5/1/2004 until 10/1/2004.
In cell E7 write a formula that will display the phrase, Effective Date in
the cell if the date entered in cell D3 is a date a rate became effective.
If a match to the date cannot be found in column A, the formula should
display Not an Effective Date.
Thanks
|