- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2007 August
- vba programming

Subject: | vba programming |

Posted by: | biker man (white…@aston.ac.uk) |

Date: | Tue, 28 Aug 2007 |

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

- Re: vba programming posted by David Biddulph on Tue, 28 Aug 2007