Formula help again

[amna77]

I have this following formula, can some one please help me modify this.
This formula looks in column AC and adds 10 working days in that date, but if in column C value = "Assy", then it does not count.

But is it possible when I have "Assy" in column C, then i want to see "N/A" in the cell, other wise add 10 working days to that date.


=IF(ISERROR(AC6/AC6)=TRUE,"",IF(C6="Assy",AC6,WORKDAY(AC6,(10))))


Thanks in advance

 

[kskinne]

replace:

=IF(ISERROR(AC6/AC6)=TRUE,"",IF(C6="Assy",AC6,WORKDAY(AC6,(10))))

with:

=IF(ISERROR(AC6/AC6)=TRUE,"",IF(C6="Assy","N/A",WORKDAY(AC6,(10))))

is this what you wanted?

hth
kevin

 

[garyae]

Ok so if the value of C6 = Assy you want to see NA in the cell that contains your formula. Is that right?
If I that is right then the following will work:
=IF(ISERROR(AC6/AC6)=TRUE,"",IF(C6="Assy","N/A",WORKDAY(AC6,(10))))

 

[amna77]

Thanks for great help