Rounding down the 54th power

[Fire Chief]

I have tried to use all the round functions i.e. round () Rnd() etc and I
can not get it to work like I want it to. This is a program that calculates
fire hydrant pressures and Gallons per minute flowed.

Here is the code for a textbox in question.

Private Sub PowerAnswer1_Click()
PowerAnswer1 = Answer1 ^ 0.54
End Sub

Work great except I get 12 or more numbers, I just want to see the first
six.

Can someone help, Thanks in advance

Ed White

 

[John Vinson]

I have tried to use all the round functions i.e. round () Rnd() etc and I
can not get it to work like I want it to. This is a program that calculates
fire hydrant pressures and Gallons per minute flowed.

Here is the code for a textbox in question.

Private Sub PowerAnswer1_Click()
PowerAnswer1 = Answer1 ^ 0.54
End Sub

Work great except I get 12 or more numbers, I just want to see the first
six.

Try

PowerAnswer1 = Val(Format([Answer1] ^ 0.54, "#.000000"))

The Format function will convert the value to a String, and Val back
into a number.


John W. Vinson[MVP]

 

[Fire Chief]

Thanks John that was actually what I needed.
Ed

I have tried to use all the round functions i.e. round () Rnd() etc and I
can not get it to work like I want it to. This is a program that
calculates
fire hydrant pressures and Gallons per minute flowed.

Here is the code for a textbox in question.

Private Sub PowerAnswer1_Click()
PowerAnswer1 = Answer1 ^ 0.54
End Sub

Work great except I get 12 or more numbers, I just want to see the first
six.

Try

PowerAnswer1 = Val(Format([Answer1] ^ 0.54, "#.000000"))

The Format function will convert the value to a String, and Val back
into a number.


John W. Vinson[MVP]