Thread: vba
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
paul[_17_] paul[_17_] is offline
external usenet poster
 
Posts: 28
Default vba

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