# Formula Sheet

#### ExcelBeginner

##### New Member
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!

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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

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!

[No message]

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

Replies
13
Views
265
Replies
1
Views
121
Replies
3
Views
188
Replies
5
Views
225
Replies
6
Views
280

Threads
1,214,278
Messages
6,118,638
Members
448,844
Latest member
Jayee04e

### 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