Recalculate using two different formulas in same cell

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

This is certainly the kind of problem I am familiar with. As Pepe suggested, a sample workbook with your exact requirements will help us give you specific advice.

In general, here's how approach this problem:

1) For the calculation/processing section of the spreadsheet, I will choose a unit system that I am comfortable with (usually SI). All the calculations in this section are based on those units.
2) For the input section, I will let the user enter values and units using the available "from units" list for the CONVERT() function. http://office.microsoft.com/en-us/ma...551.aspx?CTT=1. Then I can use the CONVERT() function to convert from the user's input units to the units I used in the processing section.
a) If I wanted this to be done by a single cell where the user inputs "unit system", I would create a lookup table where I could "define" the different unit systems I wanted to make available. An example of this kind of lookup table is at the end of the post. Then, a simple VLOOKUP() function http://office.microsoft.com/en-us/st...011.aspx?CTT=1 could be used to return the desired input and output units to the appropriate cells for each input/output value.
3) For the output section, again, I will have the user select the desired output units from the available units for the CONVERT() function. From this text string, I can again use the CONVERT() function to convert the results of my calculation section into the user's desired units.
4) The only additional thing I have done is that, since the CONVERT() function does not have a complete list of available units (especially for pressures), I created a UDF in VBA to expand the available units. This UDF is basically a collection of Select Case statements to perform the unit conversion.

Example lookup table:

Please Login or Register  to view this content.

Try the function 'convert'
For explanation :
http://office.microsoft.com/en-nz/ex...010342306.aspx

its easy enough with convert i used lookup to get the correct abbr. for the function
here is a sample drop downs in b2 and b5