Annual Salary Bonus Max
Job Title Experience (Years) ($USD) ($USD)
Data Scientist 5 120000 10000
Machine Learning Engineer 4 135000 12000
Data Analyst 2 75000 5000
Business Intelligence Dev 6 110000 8000
Data Engineer 3 125000 11000
Statistician 7 90000 7000
Data Architect 10 150000 15000
Research Scientist 8 130000 13000
AI Specialist 3 140000 14000
Big Data Engineer 5 115000 9000
Job Goals:
Experience (<=) 5
Total Salary (>=) 90000
Meets
Experience Meets Salary Meets Both Meets Goals
TRUE TRUE 1 Goal Met
FALSE TRUE FALSE Not Met
FALSE FALSE FALSE Not Met
TRUE TRUE TRUE Goal Met
FALSE TRUE FALSE Not Met
TRUE TRUE TRUE Goal Met
TRUE TRUE TRUE Goal Met
TRUE TRUE TRUE Goal Met
FALSE TRUE FALSE Not Met
TRUE TRUE TRUE Goal Met
Experience Annual Salary Bonus Max
Job Title (Years) ($USD) ($USD) Meets Goals
Data Scientist 5 120000 10000 Goal Met
Machine Learning Engineer 4 135000 12000 Not Met
Data Analyst 2 75000 5000 Not Met
Business Intelligence Dev 6 110000 8000 Goal Met
Data Engineer 3 125000 11000 Not Met
Statistician 7 90000 7000 Goal Met
Data Architect 10 150000 15000 Goal Met
Research Scientist 8 130000 13000 Goal Met
AI Specialist 3 140000 14000 Not Met
Big Data Engineer 5 115000 9000 Goal Met
Job Goals:
Experience (<=) 5
Total Salary (>=) 90000
job_title_short salary_year_avg Both Roles 85000 Buckets
Senior Data Engineer 135000 Not Desired Salary > $85k Salary > $85k
Data Analyst 35000 Role Desired Salary Low Low Salary
Data Analyst Role Desired Salary Low No Data
Data Scientist Not Desired Salary Low No Data
Senior Data Analyst Not Desired Salary Low No Data
Data Scientist Not Desired Salary Low No Data
Data Analyst Role Desired Salary Low No Data
Data Analyst 115000 Role Desired Salary > $85k Salary > $85k
Data Analyst Role Desired Salary Low No Data
Data Analyst 105000 Role Desired Salary > $85k Salary > $85k
Data Scientist 195000 Not Desired Salary > $85k Salary > $85k
Senior Data Scientist 165000 Not Desired Salary > $85k Salary > $85k
Data Scientist 281450.5 Not Desired Salary > $85k Salary > $85k
Data Scientist 70000 Not Desired Salary Low Low Salary
Data Engineer 98301.5 Not Desired Salary > $85k Salary > $85k
Data Engineer 89100 Not Desired Salary > $85k Salary > $85k
Business Analyst Role Desired Salary Low No Data
Data Scientist 87500 Not Desired Salary > $85k Salary > $85k
Data Scientist Not Desired Salary Low No Data
Business Analyst 90000 Role Desired Salary > $85k Salary > $85k
job_title_short salary_year_avg Data Analyst Business Analyst
Senior Data Engineer 135000 NOT Desired NOT Desired
Data Analyst 35000 Role Desired NOT Desired
Data Analyst Role Desired NOT Desired
Data Scientist NOT Desired NOT Desired
Senior Data Analyst NOT Desired NOT Desired
Data Scientist NOT Desired NOT Desired
Data Analyst Role Desired NOT Desired
Data Analyst 115000 Role Desired NOT Desired
Data Analyst Role Desired NOT Desired
Data Analyst 105000 Role Desired NOT Desired
Data Scientist 195000 NOT Desired NOT Desired
Senior Data Scientist 165000 NOT Desired NOT Desired
Data Scientist 281450.5 NOT Desired NOT Desired
Data Scientist 70000 NOT Desired NOT Desired
Data Engineer 98301.5 NOT Desired NOT Desired
Data Engineer 89100 NOT Desired NOT Desired
Business Analyst NOT Desired Role Desired
Data Scientist 87500 NOT Desired NOT Desired
Data Scientist NOT Desired NOT Desired
Business Analyst 90000 NOT Desired Role Desired
Both Roles =AND() =OR() Both Roles 85000
NOT Desired 0 0 NOT Desired Salary > 85K
Role Desired FALSE TRUE Role Desired Salary Low
Role Desired FALSE TRUE Role Desired Salary Low
NOT Desired FALSE FALSE NOT Desired Salary Low
NOT Desired FALSE FALSE NOT Desired Salary Low
NOT Desired FALSE FALSE NOT Desired Salary Low
Role Desired FALSE TRUE Role Desired Salary Low
Role Desired FALSE TRUE Role Desired Salary > 85K
Role Desired FALSE TRUE Role Desired Salary Low
Role Desired FALSE TRUE Role Desired Salary > 85K
NOT Desired FALSE FALSE NOT Desired Salary > 85K
NOT Desired FALSE FALSE NOT Desired Salary > 85K
NOT Desired FALSE FALSE NOT Desired Salary > 85K
NOT Desired FALSE FALSE NOT Desired Salary Low
NOT Desired FALSE FALSE NOT Desired Salary > 85K
NOT Desired FALSE FALSE NOT Desired Salary > 85K
Role Desired FALSE TRUE Role Desired Salary Low
NOT Desired FALSE FALSE NOT Desired Salary > 85K
NOT Desired FALSE FALSE NOT Desired Salary Low
Role Desired FALSE TRUE Role Desired Salary > 85K
Buckets
Salary > 85K
Salary Low
No Data
No Data
No Data
No Data
No Data
Salary > 85K
No Data
Salary > 85K
Salary > 85K
Salary > 85K
Salary > 85K
Salary Low
Salary > 85K
Salary > 85K
No Data
Salary > 85K
No Data
Salary > 85K
85000
Error Type Formula
#DIV/0! =1/0
#VALUE! =B4 + "text"
#REF! =#REF!
#NAME? =COUNTT(A3:A9)
Err:502 =VLOOKUP("Value", A1:A10, 2, FALSE)
Err:502 =SQRT(-1)
#REF! =SUM(A1:A10 B1:B10)
Description
The formula is trying to divide by zero
The formula includes an argument of the wrong type
The formula refers to a cell that isn’t valid (usually deleted cell)
The formula uses a name that Excel doesn’t recognize
The formula is referring to a cell whose data isn’t available
There is a problem with the value in the formula
The formula is trying to use an intersection of two ranges that don’t intersec
=IFERROR() =IFNA()
This text hides the error #DIV/0!
This text hides the error #VALUE!
This text hides the error #REF!
This text hides the error #NAME?
This text hides the error This hides #N/A error
This text hides the error Err:502
This text hides the error #REF!
Conditon 1 Condition 2 =AND() =OR()
TRUE TRUE 1 TRUE
TRUE FALSE FALSE TRUE
FALSE TRUE FALSE TRUE
FALSE FALSE FALSE FALSE
