vba help

H

harry buggy

im writing a VBA programme where x = 2 in cell A3 and cell B3 = 5

and in cell C3


=IF(B3<=0,"B3 must be integer greater than zero",(A3^B3)/FACT(B3))


can anyone help me write a VBA programmeto ensure that x from cell
a3
and n from cell b3 return in cell c3 the value of x raised tot he n
divided by n factorial


where x is 2 and n is 5


many thanks as im struggling on how to do this
 
M

Michael

Range("C3").FormulaR1C1 = _
"=IF(RC[-1]<=0,""B3 must be integer greater than
zero"",(RC[-2]^RC[-1])/FACT(RC[-1]))"
 

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

Similar Threads

Need help calculating probabilities 7
run programme error occuring 2
vba help with formula 0
Formula confusion 4
vba 2
vba programming 1
Need Help with Excel and Flagging Outcomes! 4
programme run help 2

Top