Making Formulas In Excel?

[dann2707]

Hey. for a lab report I am needing to convert 90 results that are in pressure (BAR) that are needed to be converting into Force (N ).

This forumale is Pressure (the 90 figures i have) x 10^5 x (PIEx D^2)/4)

What would I type into Excel to apply the same forumla to all these figures? Im aware that id have to type all the answers out in a long lone vertically.

Any ideas? Cheers.

Edited November 22, 2011 by dann2707

[Rich J]

It should be simple, column A so A1, A2 etc are the BAR numbers then column B is =Sum ((A1 x 10^5) x (PIEx D^2)/4). Assuming PIE is in excel and youll need to put in the diameter which I assume is D.

[dann2707]

I dont think ive entered it wrong, saying its errored up! I've never done this before.

Ive changed the X's to *'s too.

Edited November 22, 2011 by dann2707

[Rich J]

=SUM((A1*10^5)*(3.14*6^2)/4) that works im pretty sure if D is 6. PIE doesnt get accepted.

[dann2707]

Ahh ive typed it out ommitting any spaces and its worked amazing. Thanks for that mate.

[monkeyseemonkeydo]

Pi needs to be input as Pi()

=SUM((A1*10^5)*(3.14*6^2)/4) that works im pretty sure if D is 6. PIE doesnt get accepted.

What's the SUM doing there? Surely the SUM needs to be added at the bottom of the column it you want to total the individual forces. Adding it for each row like that won't do anything will it?

Edit: Don't forget to check the units required for D. I'm guessing metres.

[dann2707]

Yeah man its 38mm, or 0.038m which i needed it in.

Do you know how to make a graph in Excel?

I now have my Forces for one part of the question, I'm measuring it against 9 heights. but when i press turn into a graph it doesn't come up how i want it.

I want it like this on the left, but as it is its coming out on the right

[monkeyseemonkeydo]

You want a scatter plot, not a line graph.

[Sam Nichols]

Chose a scatter chart or whatever it's called then you can right click and click 'select data'. Then set Force to 'y' axis and Height to 'x' axis.

Beaten to it

[Rich J]

Pi needs to be input as Pi()

What's the SUM doing there? Surely the SUM needs to be added at the bottom of the column it you want to total the individual forces. Adding it for each row like that won't do anything will it?

I thought he wanted to turn 90 individual entries into 90 new ones, therefore would have to do 90 separate sums? Might be wrong but I also though =sum was just the way of telling excel this entry was not a number but a sum?

[dann2707]

What i did was drag that box all the way down and allowed me to enter many more figures into the a column

[monkeyseemonkeydo]

I thought he wanted to turn 90 individual entries into 90 new ones, therefore would have to do 90 separate sums? Might be wrong but I also though =sum was just the way of telling excel this entry was not a number but a sum?

Sum() gives the sum of whatever cells are indicated within the brackets. As it was written in your post each cell was giving the sum of a single number. If you needed the sum of everything in column A you'd select a new cell and put =sum(a2:a10) or whatever and the cell would then give you the total of the numbers in those 9 cells added together.

[Rich J]

Sum() gives the sum of whatever cells are indicated within the brackets. As it was written in your post each cell was giving the sum of a single number. If you needed the sum of everything in column A you'd select a new cell and put =sum(a2:a10) or whatever and the cell would then give you the total of the numbers in those 9 cells added together.

But he didnt want the total of the Column A (at least I dont think so, sorry if I am wrong?) He wanted the cell to give the total/sum of the formula that was in the brackets? Thats the way I have always used it?

EDIT: Ok so taking sum out does the same thing, is that what you are getting at?

Edited November 22, 2011 by Rich J

[Luke Rainbird]

Then you only want the cell to equal the function, not sum anything

[craigjames]

Using SUM suggests the addition of results or values from various cells to gain a total. You aren't adding anything together as you don't require a total.

Edited November 22, 2011 by craigjames

[monkeyseemonkeydo]

What they said ^^

[Rich J]

Understood. Sorry Dan if I messed you up.