How to convert units from pre-existing values

**kennechiwa87** · 07-08-2010, 05:12 PM

I have a spreadsheet with some lines similar to the lines I've concocted below.

inches 53 69 22 10
psi 22 29 56 30
SCFM 21 45 22 39

etc.

I need a way to program the numbers to change if the unit for those numbers changes. I don't think the "convert" formula will help me because I only need numbers to change from their current value if I change the unit (and because the convert formula doesn't work for some of the units I'm using).

I'm not asking how to convert to different units, but rather have something in place so that if "inches" was changed to "feet" or if "SCFM" was changed to "lbs/hr" the numbers related to inches and the numbers related to SCFM would change accordingly after I somehow imputted the formula for changing inches to feet and SCFM to lbs/hr.

Let me know if any of this doesn't make sense, and thank you so much for your help.

Kenneth

**shg** · 07-08-2010, 05:16 PM

Compute in some standard units (like SI) and then convert to whatever system of units you want for output. You can put the conversion factors in a lookup table.

**kennechiwa87** · 07-08-2010, 05:24 PM

As an addendum to my previous post, I think it would be easier for me to just create multiple IF, THEN statements with the possible unit conversions already in the statement.

Excuse me for perhaps not already knowing the answer to a simple question, but is there a way to say IF whatever, then cell = "current value" or "current value * 10"? I'm not really sure how to reference the current value of the cell without creating a circular loop.