formula help
im writing a VBA programme where x = 12 in cell A3 and cell B3 = 120
and in cell C3
=IF<, IF(B3<=0," Integer in B3 must be positive",(A3^B3)/B3)
this gives the value 4.9922E+181
when i change cell B3 to a negative value it shows " integer in b3
must be positive
is this right??? where i want cell C3 to show the value of x raised
to
the power n divided by n factorial?
and want to show that a negative value of n canot be used, where n is
cell b3
aslo do i need to qrite a vba for this too work???
also is there anyway of checking for errors in this??
thanks
|