Hi Thanks, but unfortunately i've already tried that and it doesn't work,
either that or i'm missing something, any other ideas. Thanks


"Max" wrote:

Whereby if A2 is blank (""), then put blank, otherwise perform .. formula,

Try adding a front check, viz.:
=IF(A2="","", <your_array_formula)
Remember to array-enter ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sdg8481" wrote:
Hi,

I want to add a conditional If statement to the following Array Formula;

=A2+IF(B$2=0,0,SIGN(B$2)*SMALL(IF((WEEKDAY(A2+SIGN (B$2)*(ROW(INDIRECT("1:"&ABS(B$2)*10))),2)<6)*ISNA (MATCH(A2+SIGN(B$2)*(ROW(INDIRECT("1:"&ABS(B$2)*10 ))),C$2:C$3,0)),ROW(INDIRECT("1:"&ABS(B$2)*10))),A BS(B$2)))

Whereby if A2 is blank (""), then put blank, otherwise perform the above
formula, how should this formula look, as i've tried doing it severall ways
and struggled on all.

Thansk