Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |