m=1000 c=100 e=1

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

Brent Becker

I tried =F(A1="m",1000,IF="c",100,"not defined")).

I need to look at colume that will have M or C or E in
and I need to fill another cell with a value.

M=1000, C=100 or E=1

Thanks Brent
 
Brent,

Try

=IF(A1="M",1000,IF(A1="C",100,IF(A1="E",1,"undefined")))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hi
please stay in the original thread.
Question do you want to check a complete column or only a cell in a
column. e.g. if you want to check A1 try
=IF(A1="M",1000,IF="C",100,IF(A1="E",1,"not defined")))

If this does not work please provide more information what you're
trying to do!
 
Back
Top