If functions and blank cells

[Ldsoldier]

Version: 2008 Operating System: Mac OS X 10.3 (Panther) Processor: Intel I have 2 columns of data with measurements that need to be converted. One column is in inches, the other is in centimeters. The bulk of the measurements are in inches, which means that most of the blank cells are in the centimeters column. However, a few of the centimeter cells have measurements.

How do I set up a conversion formula in the centimeter column without wiping out the information already there?

Basically I want to set it up to say something like: if f2 is blank then use value in g2, if f2 is Y, then multiply Yx2.54

Thank you for any help you can give.

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.3 (Panther) Processor: Intel
I have 2 columns of data with measurements that need to be converted.
One column is in inches, the other is in centimeters. The bulk of the
measurements are in inches, which means that most of the blank cells are
in the centimeters column. However, a few of the centimeter cells have
measurements.

How do I set up a conversion formula in the centimeter column without
wiping out the information already there?

Basically I want to set it up to say something like: if f2 is blank then
use value in g2, if f2 is Y, then multiply Yx2.54

Thank you for any help you can give.

=if(len(f2)=0,g2,f2*2.54)

 

[Ldsoldier]

Thank you. Now, how did you come up with that?

 

[Bob Greenblatt]

Thank you. Now, how did you come up with that?

Just comes naturally as a result of working with excel every day all day
since 1985.

 

[Phillip Jones, C.E.T.]

I can atest to Bob being a genius.

Just comes naturally as a result of working with excel every day all day
since 1985.