Experience Annual Salary Bonus Max
Job Title (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
Average (by Cell)
Average (AVERAGE())
Total Count
Meets Goals Count
Meets Goals Count
Meets Both - Meets Both -
Formula Only AND() Job Goals:
TRUE Experience (<=) 5
FALSE Total Salary (>=) 90000
FALSE
TRUE
FALSE
TRUE
TRUE
TRUE
FALSE
TRUE
Experience Annual Salary Bonus Max
Job Title (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
Average (by Cell) 5.3 119000 10400
Average (AVERAGE()) 5.3 119000 10400
Total Count 10 10 10
Meets Goals Count 6 9
Meets Goals Count 6 9
Meets Both - Meets Both -
Formula Only AND() Job Goals:
1 TRUE Experience (<=) 5
FALSE FALSE Total Salary (>=) 90000
FALSE FALSE
TRUE TRUE
FALSE FALSE
TRUE TRUE
TRUE TRUE
TRUE TRUE
FALSE FALSE
TRUE TRUE
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 intersect
