calculating text to result certain text resultClosed

Question

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

Mazzaropi · Answer

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

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

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

Calculating text to result certain text result

3 replies

Subscribe To Our Newsletter!