Previous Topic Next Topic

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

Answer 1 / 3
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
Answer 2 / 3
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
Answer 3 / 3
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