help for vba

H

harry

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
 
P

Pranav Vaidya

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top