Calculating text to result certain text result

Closed
simonchef
Posts
3
Registration date
Tuesday July 1, 2014
Status
Member
Last seen
July 2, 2014
- Jul 1, 2014 at 09:02 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Jul 2, 2014 at 11:03 AM
hi, if I enter S into cells a1 & b1 & c1 I need cell D1 to result 'CO'. if either cells a1,b1 or c1 has NYS entered into either cell or all 3 cells I need a result (in D1) 'Re-enrol'.

in other word ALL cells - a1, b1 & c1 must have an 'S' entered otherwise result (cell D1) should show 'Re-enrol'.


thanks

3 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jul 1, 2014 at 09:37 AM
simonchef, Good morning.

Try to use it:

D1 --> =IF(AND(A1="S",B1="S",C1="S"),"CO","Re-enrol")

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
simonchef
Posts
3
Registration date
Tuesday July 1, 2014
Status
Member
Last seen
July 2, 2014

Jul 2, 2014 at 06:24 AM
hi mazaropi,
thankyou for your answer it works great.

however I also need the cell D1 to remain empty until "s" or "nyc" are entered.

at the moment cell D1 with the formula entered shows 'Re-enrol' even though the cells above (a1,b1,c1) have no text entered.

are you able to help?

simon
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jul 2, 2014 at 11:03 AM
simonchef, Good morning.

"...in other word ALL cells - a1, b1 & c1 must have an 'S' entered otherwise result (cell D1) should show 'Re-enrol'. ..."
Well, the formula follows exactly what was described in your previous explanation.

NOW:
"...however I also need the cell D1 to remain empty until "s" or "nyc" are entered..."

Try to use it:

=IF(AND(A1="S",B1="S",C1="S"),"CO",IF(OR(A1="NYC",B1="NYC",C1="NYC"),"Re-enrol",""))


Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0