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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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
Related:

3 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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,
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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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