Hello. I am new to this forum and have searched for what I need but cannot find it.

I am looking to create an excel spreadsheet that simply converts similar units of measurement.
For example, 1000ul=1mL=0.001L and so on.
All calculations are simply multiply or divide by 100 or 1000s so this SHOULD be easy.
I tried VBA where if a certain cell (call it a1) was a number (1), then d1 (target 1,4?) would be 0.0001 and g1 (target 1,7?) would be 1000, etc.

My problem is that I think there are too many conditions. I need help creating a matrix where you can enter ANY number into ANY field...and the surrounding fields would calculate/convert properly. That's why I cant just use simple formulas in the spreadsheet.

Any help is greatly appreciated.