On Thu, 14 Nov 2013 09:02:03 -0800, bob wrote:
Is it possible to do this:

if the user enters a number in A1 (then hit tab or enter), the equivalent
length in cm will be displayed in B1

if the user enters a number in B1, the equivalent length in inches will be
displayed in A1

It's possible, but you need to write Visual Basic for Applications
code to process the "Change" event.

I don't see a straightforward way to do it purely in worksheet
formulas.



--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...