Posted to microsoft.public.excel.misc
|
|
IF statement in Array Formula's
Perfect. Thank You Very Much
"Bob Phillips" wrote:
=IF(OR(A2="",B$2=0),0,A2+SIGN(B$2)*SMALL(IF((WEEKD AY(A2+SIGN(B$2)*(ROW(INDIR
ECT("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))),ABS(B$2)))
or perhaps
=A2+IF(OR(A2="",B$2=0),0,SIGN(B$2)*SMALL(IF((WEEKD AY(A2+SIGN(B$2)*(ROW(INDIR
ECT("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))),ABS(B$2)))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"sdg8481" wrote in message
...
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:"&A
BS(B$2)*10))),2)<6)*ISNA(MATCH(A2+SIGN(B$2)*(ROW(I NDIRECT("1:"&ABS(B$2)*10))
),C$2:C$3,0)),ROW(INDIRECT("1:"&ABS(B$2)*10))),ABS (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
|