if statements
Daryl,
Thanks, this works kind of. I need it to do this for each cell from A18 to
A32 and as it compares each one write the eff or not eff to the cell that it
is comparing to...sorry I was not being very clear.
Thanks,
Dianne
"Daryl S" wrote:
Dianne -
This will look up the value in cell D3 to see if it exists in the range
A18:A32, and if it isn't there, will display "not eff", if it is there, it
will display "eff":
=IF(isna(vlookup(D3,A18:A32,1,FALSE)),"not eff","eff")
--
Daryl S
"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
|