M=1000

[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

 

[Frank Kabel]

Hi
try
=F(A1="m",1000,IF(A1="c",100,"not defined"))

 

[Bob Phillips]

=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)