drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 543
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance!
I have a column with strings.
This strings may en with values such as:
I do not want to use Countif, because this eg is gonna be used in a bigger nested formula
I need some thing like
=IF(RIGHT(A2;1)={"1";"2";"3";"4";"5"};"OK";"Wrong")
My problem comes because:
ps:
I Can't use
This is why I am trying to correct
=IF(RIGHT(A2;1)={"1";"2";"3";"4";"5"};"OK";"Wrong")
I have a column with strings.
This strings may en with values such as:
"1"
"2"
"3"
"4"
"5"
I need a formula to let me know if ig any of this values is meet"2"
"3"
"4"
"5"
I do not want to use Countif, because this eg is gonna be used in a bigger nested formula
I need some thing like
=IF(RIGHT(A2;1)={"1";"2";"3";"4";"5"};"OK";"Wrong")
My problem comes because:
If A1 end in 1, eg: "France1" I get "OK"
If A5 end in 2, eg: "Italy2" I get "Wrong"
If A5 end in 2, eg: "Italy2" I get "Wrong"
and for this 2nd eg, I need "OK"
ps:
I Can't use
5 IFS
one other column
Vlookups
one other column
Vlookups
This is why I am trying to correct
=IF(RIGHT(A2;1)={"1";"2";"3";"4";"5"};"OK";"Wrong")