stevelockridge
New Member
- Joined
- Nov 13, 2013
- Messages
- 6
I am trying to write a formula that will look at the contents of a cell (D19) and see if it contains the text "R-". If D19 contains "R-", then value of D21 for which I am writing the formula would be "240V 1-phase". If D19 doesn't contain "R-", then the value in D21 would be "460V 1-phase".
The values of D19 are like this: R-1, R-2, R-3, R-5, etc.
It can also have these values: RH-1, RH-2, RH-3, RH-5, etc.
What is the wildcard that would tell the formula to look for "R-"?
I have a working formula but there is no wildcard in it. =IF(D19="R-1","240V 1-phase","460V 1-phase")
I have tried using "R-*" but that is not working. Thanks.
The values of D19 are like this: R-1, R-2, R-3, R-5, etc.
It can also have these values: RH-1, RH-2, RH-3, RH-5, etc.
What is the wildcard that would tell the formula to look for "R-"?
I have a working formula but there is no wildcard in it. =IF(D19="R-1","240V 1-phase","460V 1-phase")
I have tried using "R-*" but that is not working. Thanks.