if statements
Hi,
I made the change but I am still getting a value error when the formula runs.
Thanks,
Dianne
"Buschwack" wrote:
"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
Hello Dianne
change the formula to read =IF(A18:A32=D3,"eff","not eff") for your first
question.
|