=AND(B2>3000,C2>2000,“Bonus”,“No Bonus”)
=IF(AND(B2>3000,C2>2000),“Bonus”,“No Bonus”)
=IFAND(B2>3000,C2>2000,“Bonus”,“No Bonus”)
=IF(=AND(B2>3000,C2>2000),“Bonus”,“No Bonus”)
which formula is correct formatting for a nested function