M=1000

  • Thread starter Thread starter Brent Becker
  • Start date Start date
B

Brent Becker

I need to have Excel 97 to look at a cell with the letter
C or M in it and put the numerical value in another cell.

i.e. m=1000 c=100

Thanks
 
=IF(A1="M",1000,IF(A1="C",100,""))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

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
Multiple AND OR functions 5
m=1000 c=100 e=1 2
Formula-Cell has a letter (C=100, M=1,000) and needs to divide? 2
Two Criteria COUNTIF 7
Nested IF & MAX Function 4
How do I copy cells from one worksheet to another based on values 2
Combine an And OR function 4

Back
Top