Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I want 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 is what i have achieved so far number 'x' is in cell A4 and number 'n' is in cell A5. to get the desired output, i key inthe formula =IF(OR(ISERROR(POWER(A4,B4)),ISERROR(FACT(B4))),"W rong parameters",POWER(A4,B4)/FACT(B4)) is this all i need to do?? does anyone no any other formulas?? and how to check for error in the programme??? cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
programme error | Excel Programming | |||
programme error | Excel Programming | |||
tote programme | Excel Programming | |||
Audit Programme | Excel Programming | |||
excel vba programme | Excel Programming |