right now I have this formula in column D.
=IF(ISERR(AA5/AA5)=TRUE,"",AA5-10)
it just take the date value from column AA and subtract 10 days from column AA date, and puts the value in coulmn D.
Now what I want to do is, I want to look in the column B, if column B has "Assembly" value in the cell, then It should subtract only 5 days instead of 10 days, rest it sould subtract 10 days.
Any idea how I am going to play with this formula?
Thanks in advance.
Amna
=IF(ISERR(AA5/AA5)=TRUE,"",AA5-10)
it just take the date value from column AA and subtract 10 days from column AA date, and puts the value in coulmn D.
Now what I want to do is, I want to look in the column B, if column B has "Assembly" value in the cell, then It should subtract only 5 days instead of 10 days, rest it sould subtract 10 days.
Any idea how I am going to play with this formula?
Thanks in advance.
Amna