Help with IF, AND & OR statements...

  • Thread starter Thread starter tecwizz
  • Start date Start date
T

tecwizz

Hi Don.

Thanks for your reply. :)

It was the princip in this formula. The values is not importent.

It could look like this.:

=IF(AND(B17>5; A19=(OR(3;D12;D11;22;10)));"True";"False")

where the values are:

B17 = 10
A19 = 22
D11 = 821
D12 = 102316

insteed of:

=IF(AND(10>5; 10=(OR(3;6;8;22;10)));"True";"False")

It should give back True and not false.

How do I get it to work?

Best regards
TecWizz :
 
I think you will have to use this idea for the referenced cells.
=and(b17>5,Or(a19={3,10,22},a19=d12))
tested with different numbers
=IF(AND(B17>5,OR(A20={1,2,3},A20=B18))=TRUE,1,2)
 
Back
Top