calling excel badasses

[Nerva]

trying to use an if statement:

this is what i am trying to accomplish, but i dont know what the right code is:

=IF(C2!=("AAA" or "VVV"" or ""CCC"),"III")

so i am trying to say if a cell does not have the texts aaa, vvv or ccc in it, but iii in that cell.

anyone?

 

[z0mb13]

I dont quite get what you mean. If you want to find cells that has iii in it, you dont even care if its AAA or VVV or CCC. it is as simple as this:
=if(c2="iii",do whatever if correct, do whatever is false)

 

[Nerva]

Originally posted by: z0mb13
I dont quite get what you mean. If you want to find cells that has iii in it, you dont even care if its AAA or VVV or CCC. it is as simple as this:
=if(c2="iii",do whatever if correct, do whatever is false)

what i am trying to do is take any particular cell, check to see what string it has, if that cell does not have AAA, VVV, or CCC in it, put OTH

 

[dustmann]

I thought the format for an if statement was =if(test, true value, false value) so maybe you need to type it in that format? I don't know that much about excel, but I might try that.

 

[her209]

=IF(OR(C2!="AAA", C2!="VVV",C2!="CCC"),"III")

If you really want to get fance, use the FINDB function to locate "AAA", "VVV", "CCC" within text, e.g., "ABCDAAAEFGH" would evaluate to TRUE.

 

[z0mb13]

Originally posted by: 3cho

Originally posted by: z0mb13
I dont quite get what you mean. If you want to find cells that has iii in it, you dont even care if its AAA or VVV or CCC. it is as simple as this:
=if(c2="iii",do whatever if correct, do whatever is false)

what i am trying to do is take any particular cell, check to see what string it has, if that cell does not have AAA, VVV, or CCC in it, put OTH

ok then u do this:
=if(and(c2<>"AAA",c2<>"VVV",c2<>"CCC"),"OTH",else whatever)

 

[z0mb13]

Originally posted by: her209
=IF(OR(C2!="AAA", C2!="VVV",C2!="CCC"),"III")

curses!!!! 😛

 

[Fenixgoon]

Originally posted by: 3cho
trying to use an if statement:

this is what i am trying to accomplish, but i dont know what the right code is:

=IF(C2!=("AAA" or "VVV"" or ""CCC"),"III")

so i am trying to say if a cell does not have the texts aaa, vvv or ccc in it, but iii in that cell.

anyone?

talk to none other than THA H-DAWG (NSFW language)

 

[Nerva]

thanks all, really appreciate it.

 

[HomeBrewerDude]

or you can use nested if statements