Thread: formula help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
biker man biker man is offline
external usenet poster
 
Posts: 10
Default 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