I Need your Help in a formula with many Array's and criteria's , as i Calculating Productivity for 12 Activity Code, and regarding to the mentioned code and Productivity, it's suppose to Reflect in next Cell the Deserved over time and next cell calculate the Bonus hours , all depending on the Mentioned Activity Code and it's Productivity

Ex : If ( J4 = "OM1" and N4="100%" So the Over Time Equal 0 and Bonus hours Equal 0, But if the Mentioned Code "OM1" productivity in N4="125%" so the Bonus Hours Equal 1 and Over Time Equal 1,...Etc for the Other Activity Codes, with considering that 2 Activities " OM11" & "OM12" always Reflect Bonus Hours as 0 Because it's not productive Activity.Note : The formula need to consider the Code & Productivity Percentage to calculate the OT * Bonus Hours, so on for "OM1" There is 4 Criteria as productivity From 100% , 125%, 150%, 175%...Etc for the Other Codes.

message edited by Ahmed_Seif

How To Fix this formula ?

I Need your Help in a formula with many Array's and criteria's , as i Calculating Productivity for 12 Activity Code, and regarding to the mentioned code and Productivity, it's suppose to Reflect in next Cell the Deserved over time and next cell calculate the Bonus hours , all depending on the Mentioned Activity Code and it's Productivity

Ex : If ( J4 = "OM1" and N4="100%" So the Over Time Equal 0 and Bonus hours Equal 0, But if the Mentioned Code "OM1" productivity in N4="125%" so the Bonus Hours Equal 1 and Over Time Equal 1,...Etc for the Other Activity Codes, with considering that 2 Activities " OM11" & "OM12" always Reflect Bonus Hours as 0 Because it's not productive Activity.

Note : The formula need to consider the Code & Productivity Percentage to calculate the OT * Bonus Hours, so on for "OM1" There is 4 Criteria as productivity From 100% , 125%, 150%, 175%...Etc for the Other Codes.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History