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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula help for calculating freight. 2
Newbie Help - IF Yes No Function 0
Lookup Across Multiple Rows / Columns 5
Calculate After hours 3
TO COPY MORE THAN INE RESULT FROM OTHER SHEET USING LOOKUP 3
Using a vlookup to search multiple criteria for one result? 7
Excel - Wich Function should I use? 1
Multiple variables to sort and sum, return values<0 with sum refer 5

Top