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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 2, 2014 at 11:03 AM
Related:
- School result software in excel free download
- Kmspico free download - Download - Other
- Gta 5 download apk pc - Download - Action and adventure
- Minecraft java edition free download - Download - Sandbox
- Minecraft bedrock free download pc - Download - Sandbox
- Five nights in anime download - Download - Adult games
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
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
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
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
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
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
"...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