Excel Function - HELP!!!!
1. ## Excel Function - HELP!!!!

I want to create a function.

Here's the Equation:

"Radius(in) X Radius(in) X 3.1416 X Height(in) X .0005787 X .803564 X 56 / 2000 = Tons"

Here is what I thought would work, I was wrong

"=QUOTIENT(=product(A1*A1*3.1416*A2*.0005787*.803564*56)/2000)"

Are there any suggestions?

Thanks, Cody

My System Specs

2. ## Re: Excel Function - HELP!!!!

Hi,

Just for clarity, what are the basic values for: -

A1
A2
what are the values 0.0005787, 0.803564, 56 & 2000 representing. This will in theory give us an answer to work to at least.
A1 =2, A2 = 2
Gives, 2*2*3.1416*2*0.0005787*0.803564*56 all devided by 2000

= 0.00130897952149966848
Is that correct?

My System Specs

Excel Function - HELP!!!! problems?

 Similar Threads Thread Thread Starter Forum Replies Last Post ekkehard.horner VB Script 1 29 Jul 2009 Tony Bansten VB Script 2 20 Jun 2008 IHateComputers Vista General 2 06 Mar 2008 fikko Vista General 3 17 Feb 2008 SlicerRod Vista General 3 04 Jan 2008