![]() |
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? |
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? |
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? |
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