Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Confusion | Excel Discussion (Misc queries) | |||
Confusion..... | Excel Discussion (Misc queries) | |||
Chart confusion | Excel Discussion (Misc queries) | |||
still have drop-down confusion | Excel Discussion (Misc queries) | |||
drop-down confusion | Excel Discussion (Misc queries) |