if formula trouble

E

elena

trying to write if formula for cells that have codes in them (e,l,c,m) and let them have values (.1,.01,.001)
 
C

CLR

...........answered in Newusers group.........

=IF(A1="","",IF(OR(A1="E",A1="L"),0.1,IF(A1="C",0.01,IF(A1="M",0.001,"ERROR"
))))


Vaya con Dios,
Chuck, CABGx3


elena said:
trying to write if formula for cells that have codes in them (e,l,c,m) and
Click to expand...
let them have values (.1,.01,.001)
 
C

CLR

You're more than welcome Elena..........glad it worked for you........

Vaya con Dios,
Chuck, CABGx3
 
Top