Cube Root

[maloneb]

Hey,

Is there anyway of programming VBA to perform a cube root of a number/variable? I need to use the function in an equation.

Cheers

 

[GlennUK]

Like this:

Excel Workbook
	A	B
1	27	3
Sheet

... sorry, just spotted that you wanted this in VBA. Will post back in a minute.

EDIT : In VBA:

Sub cuberoot()
x = 27
y = x ^ (1 / 3)
MsgBox y
End Sub

 

[Hermanito]

Result = WorksheetFunction.Power(InputNumber,1/3)

hehe, I beat GlennUK

 

[GlennUK]

Result = WorksheetFunction.Power(InputNumber,1/3)

hehe, I beat GlennUK

ha ha ... I'll learn to be quicker in future

 

[maloneb]

It's ok guys, I realised i was being an idiot just before you posted. Of course it ^(1/3)! It seems I can't do simple maths this morning.

Cheers though!