Nested If Statement

[JAeEM]

Hi Team,

I hope you guys are doing great. How do I write an if statement that returns a value based on the values in 3 different cells for example:

CELL 1 CELL 2

IF VALUE IN CELL 1 = "TAC", IF NOT SVOD
IF VALUE IN CELL 2 = "SVOD", IF NOT TAC
IF VALUE IN BOTH CELLS = CELL 1 AND CELL 2, "TAC/SVOD"

This is what I have so far:

=IF(AD971<=0,"SVOD",IF(AD971>=1,"TAC",IF(AND(AD971>=1,AK971>=1),)))

its not returning "TAC/SVOD" when both conditions are met. Please help. Thank you all stars!

 

[bosco_yip]

Try

=IF((AD971>0)*(AK971>0),"TAC/SVOD",IF(AD971>0,"TAC",IF(AK971>0,"SVOD","")))

Regards
Bosco