View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sdg8481 sdg8481 is offline
external usenet poster
 
Posts: 29
Default IF statement in Array Formula's

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