Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / July 2007

Tip: Looking for answers? Try searching our database.

help for vba

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
harry - 22 Jul 2007 17:45 GMT
does anyone no how to answer a proposed question like this. I was
looking through some old papers for next years module in this. As im
doing this as a module on my course and I want to get a head start in
understanding how to write this in essay formats.

any hints or clues would be very grateful in how to approach this. as
this will be helpful next year

I also want you to redo the continuous assessment assignment - but an
easy one this time. I require you to write a program that takes a
number,x, from cell A3 and a positive  integer, n, from cell B3 then
returns into cell C3 the value of x raised to the power n divided by
n factorial. I will award you bonus marks if you put in some error
checking to ensure that a negative value of n cannot be used. Note
that x can be positive or negative. This will be examined orally on
the day of your examination, but should only take a few minutes
Pranav Vaidya - 23 Jul 2007 09:06 GMT
I think this belongs to Excel..here's the answer

Your number 'x' is in cell A4 and number 'n' is in cell A5. to get the
desired output, key in the below formula-

=IF(OR(ISERROR(POWER(A4,B4)),ISERROR(FACT(B4))),"Wrong
parameters",POWER(A4,B4)/FACT(B4))
Signature

Pranav Vaidya
VBA Developer
PN, MH-India

> does anyone no how to answer a proposed question like this. I was
> looking through some old papers for next years module in this. As im
[quoted text clipped - 12 lines]
> that x can be positive or negative. This will be examined orally on
> the day of your examination, but should only take a few minutes
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.