Mashiane Expert Licensed User Longtime User Oct 7, 2015 #1 Hi I need to return a value from this function, assuming B2 and D2 are some variable names. This is an excel function Code: Return PI()*B2*D2^2 PI() is the PI function .2 means to the power 2 Any ideas someone in doing this via b4a/b4i? Ta!
Hi I need to return a value from this function, assuming B2 and D2 are some variable names. This is an excel function Code: Return PI()*B2*D2^2 PI() is the PI function .2 means to the power 2 Any ideas someone in doing this via b4a/b4i? Ta!
udg Expert Licensed User Longtime User Oct 7, 2015 #2 Code: dim b2, d2, result as double d2 = ... b2 = ... result = cPI * B2 * Power(D2,2) Upvote 0
wonder Expert Licensed User Longtime User Oct 7, 2015 #3 udg said: Code: dim b2, d2, result as double d2 = ... b2 = ... result = cPI * B2 * Power(D2, 2) Click to expand... Correct. Upvote 0
udg said: Code: dim b2, d2, result as double d2 = ... b2 = ... result = cPI * B2 * Power(D2, 2) Click to expand... Correct.
S sorex Expert Licensed User Longtime User Oct 7, 2015 #4 if you hate typing you could use *(D2*D2) instead which is also a lot faster than the power function (for power 2 results) Upvote 0
if you hate typing you could use *(D2*D2) instead which is also a lot faster than the power function (for power 2 results)
Mashiane Expert Licensed User Longtime User Oct 7, 2015 #5 Thank you udg, wonder and sorex. Will test this out and revert back. Upvote 0
