Filter Employees by Salary and Tenure
From Wikiprompt, the free prompt encyclopedia
Mar 24, 2026
Filter Employees by Salary and Tenure Use FILTER with multiple conditions to display matching rows.
Prompt ContentSave
🌐
Salary is in E, start date in B. Write a formula to show only employees with salary > 70K and tenure > 5 years.
Sign in to see the full prompt
Continue with:
By logging in, you agree to our Terms of Use and Privacy Policy
Usage
This prompt is designed for use with productivity. Copy the prompt content above and paste it into your preferred AI tool.
For best results, you may customize the placeholders (indicated by square brackets or capital letters) with your specific requirements.
Talk
0 comments