Windows Vista Forums

Excel Function - HELP!!!!
  1. #1
    CodyB65's Avatar

    Junior Member
    Join Date : Jan 2012
    Posts : 24
    Vista Ultimate 32bit
    Local Time: 01:04 AM

    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

    Last edited by CodyB65; 13 Feb 2012 at 02:35 PM. Reason: Added a question
      My System SpecsSystem Spec

  2. #2
    Lottiemansion's Avatar

    Senior Member



    Join Date : Sep 2010
    Sheffield
    Posts : 1,818
    Vista Home premium 32 bit (SP2 plus)
    Local Time: 07:04 AM
    uk uk yorkshire

     

    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 SpecsSystem Spec

Excel Function - HELP!!!! problems?

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Calling excel function ekkehard.horner VB Script 1 29 Jul 2009
Is there a write-multi-cell-at-once function in VBS for Excel? Tony Bansten VB Script 2 20 Jun 2008
Excel IF Function Help IHateComputers Vista General 2 06 Mar 2008
Excel function fikko Vista General 3 17 Feb 2008
VBA Function not recognized in Excel SlicerRod Vista General 3 04 Jan 2008