IF & and / Or Formula i think

February 10, 2014 at 05:57:03
Specs: Windows 8
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


See More: IF & and / Or Formula i think

Report •


#1
February 10, 2014 at 06:07:30
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.

Report •
Related Solutions


Ask Question