if formula trouble

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

trying to write if formula for cells that have codes in them (e,l,c,m) and 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)
 
You're more than welcome Elena..........glad it worked for you........

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

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

Scrabble Value calculation for Welsh words 0
IF Function based on right value 10
TO COPY MORE THAN INE RESULT FROM OTHER SHEET USING LOOKUP 3
Lookup Across Multiple Rows / Columns 5
Multiple variables to sort and sum, return values<0 with sum refer 5
Change formulas in a column based on a selection. 3
Help creating a formula 15
Array Formula for a Finite Series Sum ?? 3

Back
Top