Change cell based on input

[Derek Mccormick]

I was wondering if there is a way to say change a cell based on the input into cell.

Example Column C is Net Weight
Input c1 with 2.2
After input it changes to 1
Input c2 with 1
Changes to 0.5

So the basic concept is I want a column to enter in lbs and get that same column to convert to kg.

 

[NARAYANK991]

Hi ,

If you want what ever is entered to change , there are two points to note :

1. Only VBA can do this

2. You can never catch data entry mistakes.

If you are willing to settle for using a second column for the output :

1. You can use a simple formula involving a native Excel function called CONVERT

2. Since the input data is always available , mistakes can be noticed

Just use the formula :

=CONVERT(inputdata , "lbm","g")/1000

where inputdata refers to the cell which will have the data in pounds.

Narayan