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

 

[Joe4]

Use a nested if statment (and if statement within an if statement):

=IF(ISERR(AA5/AA5)=TRUE,"",IF(AB5="ASSEMBLY",AA5-5,AA5-10))

 

[eliW]

On 2002-10-30 16:19, amna77 wrote:
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

Try:

IF(LEN(AA5)=0,"",IF(B5="Assembly",AA5-5,AA5-10))

Eli
This message was edited by eliW on 2002-10-30 16:31

 

[Dave Patton]

On 2002-10-30 16:19, amna77 wrote:
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

try

=IF(AND(B5="Assembly",ISNUMBER(AA5)),AA5-5,IF(ISNUMBER(AA5),AA5-10,""))