View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
harry buggy harry buggy is offline
external usenet poster
 
Posts: 8
Default Formula confusion

im writing a VBA programme where x = 12 in cell A3 and cell B3 = 234

and in cell C3

=IF<, IF(B3<=0," Integer in B3 must be positive",(A3^B3)/B3)

this gives the value 1.4428E+250

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

also is there anyway of checking for errors in this??

thanks