# 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
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,

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
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