if Cell is "FL Broward"=Broward else Cell "FL Miami"=Dade
 

I am tring to make my Excel sheet convert name/txt base on condition

if cell B2= FL Broward result Broward
else Cell B2 = FL Miami resut Dade
else cell b2 = West Palm Beach result Palm Beach

In a separate cell? If so then just use a simple formula

=IF(B2="FL Broward","Broward",IF(B2="FL Miami","Dade","Palm Beach"))

--
HTH

Bob Phillips

"Excell text convert in same cell" <Excell text convert in same
wrote in message
...
I am tring to make my Excel sheet convert name/txt base on condition

if cell B2= FL Broward result Broward
else Cell B2 = FL Miami resut Dade
else cell b2 = West Palm Beach result Palm Beach