i just wanted to no by entering this into a cell "C3", the following

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

FACT (B3) will give you the Factorial of the value in B3.

is this a VBA programme or do i need to write in visual basic for it
to be a vba programme?

just wanted to know?

FACT is an excel worksheet functioon and doesn't require VBA code.

"biker man" wrote:

i just wanted to no by entering this into a cell "C3", the following

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

FACT (B3) will give you the Factorial of the value in B3.

is this a VBA programme or do i need to write in visual basic for it
to be a vba programme?

just wanted to know?

That looks like a formula in a cell, not VBA.
--
David Biddulph

"biker man" wrote in message
oups.com...
i just wanted to no by entering this into a cell "C3", the following

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

FACT (B3) will give you the Factorial of the value in B3.

is this a VBA programme or do i need to write in visual basic for it
to be a vba programme?

just wanted to know?

On 28 Aug, 15:19, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
That looks like a formula in a cell, not VBA.
--
David Biddulph

"biker man" wrote in message

oups.com...



do you no how to write this into a vba programme?














i just wanted to no by entering this into a cell "C3", the following

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

FACT (B3) will give you the Factorial of the value in B3.

is this a VBA programme or do i need to write in visual basic for it
to be a vba programme?

just wanted to know?- Hide quoted text -

- Show quoted text -