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