As a side note, I "think" this equation gives the same results. I may be
wrong though.

=(1-$B$27/$B$28)^($B31-C$30)*($B$27/$B$28)^C$30*COMBIN($B31,C$30)

vs.
",(COMBIN($B31,C$30)*(COMBIN($B$28-1,$B$27-1)/COMBIN($B$28,$B$27))^C$30)*(1-COMBIN($B$28-1,$B$27-1)/COMBIN($B$28,$B$27))^($B31-C$30)

--
Dana DeLouis
Win XP & Office 2003


"Paul Black" wrote in message
oups.com...
Hi Everyone,

I would like a Macro that Inserts the Following Formula into an Excel
Sheet in the Cells "C31:J95" Please. It will have the Format of "%" and
be Two Decimal Places. I am Finding this Difficult Because of the
Relative and Absolute References etc. I know that if I Insert this
Formula into Cell "C31" and Copy Across and Down to Cell "J95" it
Works.

Here is the Formula :-
=IF(ISERROR((COMBIN($B31,C$30)*(COMBIN($B$28-1,$B$27-1)/COMBIN($B$28,$B$27))^C$30)*(1-COMBIN($B$28-1,$B$27-1)/COMBIN($B$28,$B$27))^($B31-C$30)),"
",(COMBIN($B31,C$30)*(COMBIN($B$28-1,$B$27-1)/COMBIN($B$28,$B$27))^C$30)*(1-COMBIN($B$28-1,$B$27-1)/COMBIN($B$28,$B$27))^($B31-C$30))

Thanks in Advance.
All the Best.
Paul