Combine formula help

[amna77]

Hi I have 2 formulas, I am having a hard time combaining them

ok here is the first one.
=IF(ISERR(A20/A20)=TRUE,"",A20+10-IF(C20="Assy",10,))

Basically it takes the date from A20 cell, and forward 10 days, but if in cell C20, I have assy then it does not add 10, it leaves the same date.

Ok here is my second formula.
=WORKDAY(A20,(10))
this does is,it takes the date from A20 and add only 10 working days in it.

Thats what I want in my formula as well. In my first formula, I am adding 10 days, instead on only 10 days, I want to add 10 working days.
Can some one help me with this, like how I may combine this.

Thanks

 

[Corticus]

Hi,

I was a little confused about your goal, but I think I got it:

=IF(ISERR(A4/A4)=TRUE,"",IF(C4="Assy",A4,WORKDAY(A4,10)))

HTH,
Corticus
This message was edited by Corticus on 2002-11-06 13:58