If statment

[amna77]

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

 

[Jac]

I would have a play around with a nested IF formula as below:
=IF(ISERR(AA5/AA5)=TRUE,"",IF(B5="Assembly",AA5-5,AA5-10))

 

[dave_219]

Hi this is David, try this:

=IF(ISERR(AA5/AA5)=TRUE;"";IF(B5>0;AA5-5;IF(B5=0;AA5-10;0)))
This is an arrey so don't forget to press Ctrl Shift Enter.
What it does is it checks to see if there is any value in cell B5 if it does the it -5 if there is nothing in cell B5 then it -10.
Hope this is what you need

later
david

 

[IML]

Perhaps
=IF(LEN(AA5),(AA5-5)-(B5<>"Assembly")*5,"")

would work for you.

 

[IML]

Just noticed this is a duplicate of
http://216.92.17.166/board/viewtopic.php?topic=27335&forum=2&3