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

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

Guest

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
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top