"IF" formula to check several cells.

**Case1979** · 05-07-2010, 06:38 AM

Hello! I need some help with this formula:

=IF(A3;D3;F3;J3;"20DV";"Answer";"",IF(A3;D3;F3;J3;"40DV";"Answer";""))

What I want it to do is to check these cells and if any of the contain either "20DV" or "40DV" It should return an answer. All the cells doesn't need to contain this information.. How do I do.. I totally screwed this up! :/

**pike** · 05-07-2010, 07:03 AM

maybe

Please Login or Register  to view this content.

**Case1979** · 05-07-2010, 07:25 AM

Originally Posted by pike

maybe

Please Login or Register  to view this content.

Thanks man!

I'll try it right away! :P

EDIT: Didn't work..

I tried this: =OM(ELLER(A3="20DV",E3="20DV",I3="20DV",M3="20DV",Q3="20DV",U3="20DV"),"Answer","")

I use the Swedish version of Excel where OM=IF and ELLER=OR.. Anyone please..

**NBVC** · 05-07-2010, 07:53 AM

Did you replace all the commas with semicolons for your version?

=OM(ELLER(A3="20DV";E3="20DV";I3="20DV";M3="20DV";Q3="20DV";U3="20DV");"Answer";"")

you also did not at the 40DV criteria into the formula...

**Case1979** · 05-07-2010, 08:39 AM

Originally Posted by NBVC

Did you replace all the commas with semicolons for your version?

=OM(ELLER(A3="20DV";E3="20DV";I3="20DV";M3="20DV";Q3="20DV";U3="20DV");"Answer";"")

you also did not at the 40DV criteria into the formula...

Hmm.. you are right about that one.. Should be semicolons. I'll try again!

Thanks!