Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"