#1
|
|||
|
|||
Excel Function
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" The Radius I want to use cell "A1" and the Height cell "A2" and put the Answer in cell "A3". I have no clue so here is what I thought would work, I was wrong "=QUOTIENT(=product(A1*A1*3.1416*A2*.0005787*.8035 64*56)/2000)" Are there any suggestions? To make this true, what do I need to Change? Thanks |
#2
|
|||
|
|||
Quote:
I would, however use PI() instead of 3.1416. Pi is an Excel function. Also, you can square cell A1 by using A1^2 instead of A1*A1. (A1^3 would be A1 cubed, and so forth) Try using: "=A1^2*PI()*A2*0.0005787*0.803564*56/2000" |
#3
|
|||
|
|||
Quote:
Thank you so much! Cody |
#4
|
|||
|
|||
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to use now() function | gsrikanth | Excel | 1 | 01-07-2012 01:18 AM |
How to "deactivate" the Excel's SAVE function | KIM SOLIS | Excel | 1 | 11-05-2011 01:57 AM |
if function help | jim831 | Excel | 2 | 10-29-2010 07:06 PM |
Help! for using an appropriate function/Macro in Excel | pawan2paw | Excel | 1 | 06-04-2009 12:28 PM |
Need help on what function to use??? | Primeraman | Excel | 1 | 06-13-2006 10:16 AM |