LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Confusion Wanna Learn Excel Discussion (Misc queries) 3 July 16th 07 05:14 PM
Confusion..... Eric @ CMN, Evansville Excel Discussion (Misc queries) 2 December 27th 05 07:15 PM
Chart confusion Gordon Byrne Excel Discussion (Misc queries) 0 June 14th 05 12:14 PM
still have drop-down confusion joe smith Excel Discussion (Misc queries) 1 March 15th 05 12:54 AM
drop-down confusion joe smith Excel Discussion (Misc queries) 0 March 11th 05 03:21 PM


All times are GMT +1. The time now is 04:08 PM.

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"