ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   vba (https://www.excelbanter.com/excel-discussion-misc-queries/156069-vba.html)

biker man

vba
 
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?


joel

vba
 
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?



David Biddulph[_2_]

vba
 
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?




biker man

vba
 
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 -





All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com