← All tasks
🧮
Data Analysis Advanced

IF With AND

⏱ 6 min ⭐ 200 XP 🔁 3 attempts allowed

What you'll do

Combine conditions.

Scenario

Sales are in B2 and region in C2. In D2 return "Bonus" if B2>1000 AND C2="North", otherwise "None".

Ready to try it?

Create a free account and try "IF With AND" free for 7 days, no card required. Earn 200 XP and track your internship progress.

Already have an account? Sign in