G Guest Apr 17, 2004 #1 trying to write if formula for cells that have codes in them (e,l,c,m) and let them have values (.1,.01,.001)
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 Apr 18, 2004 #2 ...........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)
...........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 Apr 18, 2004 #4 You're more than welcome Elena..........glad it worked for you........ Vaya con Dios, Chuck, CABGx3
