Automatically convert KG to LBS in a blank cell.

[Yordibulk]

Hi all,
My first post, and i'm not an excel wizard.

i'm currently working on an excel book with more sheets. 2 sheets are in LBS, and 1 sheet is in KG (because of the country differences).

What i would like is whenever we put something in Cell E2 (and so on) it automatically converts it to LBS

So for example Cell E2 blank cell (only formula) if i put 1Kg it automatically changes the number to 2.2LBS

is there a formula for this?

Please help me.

 

[Yordibulk]

It worked!

it was an option to not show the zero's ... easy like that.

thanks for your help Mark!

 

[MARK858]

Happy it helped and welcome to the forum