Correct Syntax for IF statement

[ddub25]

How can I adapt this formula to just return the result in AP630 if the argument is FALSE? I want to keep in tact the structure of the formula that allows me to filter my table results and gain totals only for the visible filtered results.

=IF(AH631<>"",SUBTOTAL(9,AD631)+N(AP630),"--")

Can anyone help?

Dan

 

[mowgli212001]

=if(ah631<>"",subtotal(9,ad631)+n(ap630),ap630)

 

[ddub25]

Thanks Mowgli.

Dan