Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How could I express the following as a Text string
I have 3 Names in A1:A3 (Jim; Bob; Mike); in B1:B3 is a value of either 1 or 0 (1;0;1). I wish to construct an opening statement depending if the values in B1:B3 are 1, so for example if B1=1;B2=0 and B3=1 my opening statement would be: Dear Jim / Mike if B1=0;B2=0 and B3=1 my opening statement would be: Dear Mike if B1=1;B2=1 and B3=1 my opening statement would be: Dear Jim / Bob / Mike if B1=0;B2=0 and B3=0 my opening statement would be: <blank I have 5 names in total so haven't put all the permutations above, perhaps there is not an easy way to do this |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Points Joined by Spiral !! | Charts and Charting in Excel | |||
Can 3810 and 3819 and 3806 be joined into one cell | Excel Worksheet Functions | |||
Can I lock 2 columns together so that the 2 cells in a row are joined? | New Users to Excel | |||
Joined Combo Boxes | Excel Discussion (Misc queries) | |||
Need to unhide 2 columns that I joined together - Help! | Excel Discussion (Misc queries) |