# Formula Troubles

#### pk1985

##### New Member
Hey all,

Sort of a novice to excel here...

I'm having a huge amount of difficulty getting excel to understand what I'd like. Essentially, I want to take data I input into three separate columns and have it inputted into an equation. The equation is 0.5(4/3*(pi*a*b*c)). Four-thirds multiplied by pi multiplied by a multiplied by b multiplied by c, all divided by 2.
a, b, and c are essentially values from columns 1,2, and 3.
Each time I input = followed by my equation in the cell I want it to appear (including selecting the appropriate cells from which to import the values of a,b, and c), an error message pops up. If I need to pare down the equation more simple to allow for this to work, I can.

Any help is appreciated. Thanks!

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Suppose your data are in A2, B2 and C2. In D2 (or some cell in row 2), you might write:

=A2*B2*C2*PI()*4/3/2

or

=A2*B2*C2*PI()*2/3

or if you prefer:

=0.5*(4/3)*PI()*A2*B2*C2

I appreciate your help with this matter. Unfortunately, no matter how I input this, the cell that should display the calculated value has a ‘#NAME?’ Error associated with it. Any tips?

Hi,

Did you input the pi function like PI() , with the brackets exactly like joeu2004 shown in Post # 2 ?

Ah-ha! That did it.

Thank you all for your help. Lifesavers!

You're welcome, welcome to the forum, glad we can help.

FYI, the () is how Excel differentiates an Excel Function compared to the Text/Word PI (i.e., if you type "today" without quotes, in a cell, it's just Text, but if you type "today()" without quotes, now Excel knows you want the TODAY function).

My wording was terrible above, let me rephrase:

FYI, the () is how Excel differentiates an Excel Function compared to the Text/Word PI (i.e., if you type "today" without quotes, in a cell, it's just Text, if you type "=today" or have "today" without quotes anywhere after an equal sign, due to the equal sign, Excel knows you wrote a formula, but "today", by itself is Not a function and is just Text, so you get #NAME? error, if you type "=today()" or anywhere after an equal sign, without quotes, now Excel knows you want the TODAY function).

Last edited:

Replies
3
Views
2K
Replies
0
Views
328
Replies
5
Views
190
Replies
1
Views
232
Replies
0
Views
308

Threads
1,203,545
Messages
6,056,033
Members
444,840
Latest member
RazzelDazel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back