Condition if & AND

[kabali]

Hi,

I have a multiple sheets in an excel workbook. The integers 1 and 2 have already been assigned to "Yes" and "No" respectively in each sheets.
What I want to do is that to creating vba code for the following conditions if:
- Q13 = yes and Q15 = No, it means, condition is met
- Q13 = No and Q15 = Yes, it means, condition is met
- Q13 = Yes and Q15 = Yes, it means, condition is met
if not, Not met

I want it to be display the output under the column F by offset 1 row

Please help on this creating a vba code

 

[DanteAmor]

Do you want the macro for one sheet or for all the sheets in the book?
The result in F14 or in F16?

Do you have more conditions in the sheet, that is, for example in cells Q17 and Q19?

Or maybe you just need this formula:

Dante Amor
	A				E	F	G									P	Q
1
12
13																	NO
14
15																	YES
16						Met
Hoja5

Cell Formulas
Range	Formula
F16	F16	=IF(Q13&Q15="NONO","No met","Met")

 

[kabali]

Do you want the macro for one sheet or for all the sheets in the book?
The result in F14 or in F16?

Do you have more conditions in the sheet, that is, for example in cells Q17 and Q19?


Or maybe you just need this formula:

Dante Amor
	A				E	F	G									P	Q
1
12
13																	YES
14
15																	NO
16						Met
Hoja5

Cell Formulas
Range	Formula
F16	F16	=IF(AND(Q13="NO",Q15="NO"),"No met","Met")

Or:

=IF(Q13&Q15="NONO","No met","Met")

I want the macro for all sheets. And the output should be displayed "DestinationSheet" under column F2

 

[kabali]

I want the macro for all sheets. And the output should be displayed "DestinationSheet" under column F2

and yes, the same exact formula needs to be used f

 

[Fluff]

Duplicate to:

Please stop duplicating your question. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.