Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |