I need to put a formula together which does the following, but am struggling.
Here is what is required.
Columns U, V & W have either an X or are blank. I want to put the result of varying combinations of the Xs in another column.
So In English, IF W2 =X, then the result will be x. If U2 & V2 both have an X, the result will be **, otherwise the result will be *
Just to clarify, if there is an X in column W, the will never be an X in U or V. If there is an X in either U or V, there will never be an X in W.
Only 3 possibly scenarios exist
1) U2=X, V2=X, W2=Blank - Result =**
2) U2=X, V2=Blank, W2=Blank - Result = *
3) U2=Blank, V2=Blank, W2=X - Result = x
I tried starting with
but the result gives me #NAME? I thought this was saying IF W2 = "X" put x, IF U2="X" AND V2="X" then put "**", otherwise put "*"
Any help gladly accepted
cheers
Here is what is required.
Columns U, V & W have either an X or are blank. I want to put the result of varying combinations of the Xs in another column.
So In English, IF W2 =X, then the result will be x. If U2 & V2 both have an X, the result will be **, otherwise the result will be *
Just to clarify, if there is an X in column W, the will never be an X in U or V. If there is an X in either U or V, there will never be an X in W.
Only 3 possibly scenarios exist
1) U2=X, V2=X, W2=Blank - Result =**
2) U2=X, V2=Blank, W2=Blank - Result = *
3) U2=Blank, V2=Blank, W2=X - Result = x
I tried starting with
VBA Code:
=IF(W2="X",x,IF(AND(U2="X",V2="X"),"**","*"))
Any help gladly accepted
cheers