Quick Help With A Cell Formula Issue

[BigGoose62]

I'm hoping someone here can help me with this issue. I will first describe what my goal is, and then how I've tried to accomplish it.

1. I need 2 (or more) cells to display information converted to different units
-example: first cell is in lbs, second cell is in kg
2. I need to be able to enter a number in 1 cell and have the other cell convert to it's units
-example 1: enter 70 kg into first cell, second cell displays 154 lbs
-example 2: enter 154 lbs into first cell, second cell displays 70 kg



I tried using the following formula, but it's not working out.

=IF((F16="kg"),(F16*2.2" lbs"), IF((F16="lbs"),(F16/2.2" kg")))

In this case, I'm entering "70 kg" into the first cell, and expecting "154 lbs" to display in the second cell.


Any help is greatly appreciated. If I need to explain further, I will.

[AlKey]

Your formula as written can't work. I suspect the correct version maybe something like this:

Please Login or Register  to view this content.

[BigGoose62]

Your formula as written can't work. I suspect the correct version maybe something like this:

Please Login or Register  to view this content.

Thank you! Much appreciated!

[AlKey]

You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

[BigGoose62]

Will do. One more quick question though. is it possible to have both cells be able to accept a numerical value for the other to convert? Think of a simple converter that only has two fields side by side. One is kg and the other is lbs. Whichever field you enter a number into, the other field displays the number in it's units. Is this possible?

[unit285]

I'm no expert by any means but from my standpoint there would be no way to do that without using a Macro.. You could do something like this:
Put the following formula into C1 and then input your value into A1 and your measurement (KG or LBS) into B1

Please Login or Register  to view this content.