Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with If,then statement Returning Value (or Select Case)
Hello, any help is appreciated. I have four cells (A1 thru A4). I want
to display (1) in B1 if just A1 contains any text, or I want to display (1) and (2) in B1 if cells A1 and A2 both contain text, or display (1),(2), and (3) in B1 if A1,A2,and A3 contain text, or display (1), (2), (3), and (4) in B1 if A1 thru A4 have any text in them. Sorry if this has already been covered somewhere...I did check...Thanks for any help guys/gals. Bull |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with If,then statement Returning Value (or Select Case)
Can you live with something like:
(1),(2),(4) If yes, you could use this formula in B1: =SUBSTITUTE(TRIM(IF(A1="","","(1) ") & IF(A2="","","(2) ") & IF(A3="","","(3) ") & IF(A4="","","(4) "))," ",",") wrote: Hello, any help is appreciated. I have four cells (A1 thru A4). I want to display (1) in B1 if just A1 contains any text, or I want to display (1) and (2) in B1 if cells A1 and A2 both contain text, or display (1),(2), and (3) in B1 if A1,A2,and A3 contain text, or display (1), (2), (3), and (4) in B1 if A1 thru A4 have any text in them. Sorry if this has already been covered somewhere...I did check...Thanks for any help guys/gals. Bull -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with If,then statement Returning Value (or Select Case)
Thank you. It would be ok if it was up to me...but it requires a little
more...but again, appreciate your help. Dave Peterson wrote: Can you live with something like: (1),(2),(4) If yes, you could use this formula in B1: =SUBSTITUTE(TRIM(IF(A1="","","(1) ") & IF(A2="","","(2) ") & IF(A3="","","(3) ") & IF(A4="","","(4) "))," ",",") wrote: Hello, any help is appreciated. I have four cells (A1 thru A4). I want to display (1) in B1 if just A1 contains any text, or I want to display (1) and (2) in B1 if cells A1 and A2 both contain text, or display (1),(2), and (3) in B1 if A1,A2,and A3 contain text, or display (1), (2), (3), and (4) in B1 if A1 thru A4 have any text in them. Sorry if this has already been covered somewhere...I did check...Thanks for any help guys/gals. Bull -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with If,then statement Returning Value (or Select Case)
wow, thanks. I am trying to figure out how to put this one in.
Martin Fishlock wrote: Dear Mrs Bull Foreman: This is one way to do it: Dim szAns As String With ActiveSheet.Range("A1:A4") If .Cells(1) = "" Then szAns = "" Else szAns = "(1)" If .Cells(2) < "" Then If .Cells(3) = "" Then szAns = szAns & " and (2)" Else szAns = szAns & ", (2)" If .Cells(4) = "" Then szAns = szAns & " and (3)" Else szAns = szAns & ", (3) and (4)" End If End If End If End If End With -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. " wrote: Hello, any help is appreciated. I have four cells (A1 thru A4). I want to display (1) in B1 if just A1 contains any text, or I want to display (1) and (2) in B1 if cells A1 and A2 both contain text, or display (1),(2), and (3) in B1 if A1,A2,and A3 contain text, or display (1), (2), (3), and (4) in B1 if A1 thru A4 have any text in them. Sorry if this has already been covered somewhere...I did check...Thanks for any help guys/gals. Bull |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with If,then statement Returning Value (or Select Case)
thanks, this fixed it giles...appreciate everyone's help here. Take
care. BULL Giles (NoSpam) wrote: Here is a nice simple formula to put in cell B1 =CHOOSE(COUNTA(A1:A4),"(1)","(1)(2)","(1)(2)(3)"," (1)(2)(3)(4)") hth Giles " wrote: Hello, any help is appreciated. I have four cells (A1 thru A4). I want to display (1) in B1 if just A1 contains any text, or I want to display (1) and (2) in B1 if cells A1 and A2 both contain text, or display (1),(2), and (3) in B1 if A1,A2,and A3 contain text, or display (1), (2), (3), and (4) in B1 if A1 thru A4 have any text in them. Sorry if this has already been covered somewhere...I did check...Thanks for any help guys/gals. Bull |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Case Statement | Excel Worksheet Functions | |||
select case statement? | Excel Programming | |||
Select Case within IF-Else statement | Excel Programming | |||
select case statement | Excel Programming | |||
Convert If..Else to Select Case Statement. | Excel Programming |