Formula Sheet

ExcelBeginner

New Member
Joined
Sep 10, 2002
Messages
7
I am supposed to make a formula sheet for my boss that will calculate the answers to formulas and allow him to convert units. For example: the cylinder pressue formula is P=F/A I need to have him enter F and A and return the value P. I can handle that much but P is measured in lb/in^2 usually. He needs to be able to enter F and A in lb, g, kg, in, m, ft, and cm. Then, I have to return the answer in lb/in^2 , g/cm^2, kg/m^2, oz/ft^2, etc. I have no idea how to do this. I looked up conversions in Excel but the funtionality isn't loaded. Even if it was, I am not sure how to format this. Any syggestions would be greatly appreciated!
Thanks!
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

JugglerJAF

Active Member
Joined
Feb 17, 2002
Messages
271
The CONVERT function is part of the Analysis Tool Pak.

Do a search on convert and select "CONVERT worksheet function" - this should give you all you need.


JAF
 

ChrisUK

Well-known Member
Joined
Sep 3, 2002
Messages
675
All you're wanting to do is convert from imperial to metric or visa versa. There will be a single figure you can use for this. For example there are 2.2lb's in a Kg so give 2Kg multiply by 2.2 to get the pounds!
 

ExcelBeginner

New Member
Joined
Sep 10, 2002
Messages
7
I will try those ideas momentarily. Thanks for the help. Out of those questions arises another - how can I do this without having 30 different lines for each formula? The sheet will look horrible if I have to write out every combination of the formaula possible. Is there someway that I could AutoFilter or something so my boss can pick that he wants F in lbs and A in ft and then I can calculate it?

Also, is there something wrong with the statement =CONVERT (A1,from_ft,to_m)
I want to take the number in cell A1 and convert it but Excel won't do it.
This message was edited by ExcelBeginner on 2002-09-11 11:05
 

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,720
Members
414,401
Latest member
grenona2020

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

Which adblocker are you using?

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
Top