Angello's Distributing needed inventory numbers to be updated in real-time by 4 staff members. Below are some examples of the formulas I created for that company.
June 2011 - Problem Solving
When working for Coarc, I had to make adjustments to the following Excel formula. It should be noted that I am completely self-taught.
The first step was to break down the formula so that I could 'read' it in English:
I then wrote out in English what I needed the final formula to 'say' and 'translated' those English sentences into Excel formulas. (Click to enlarge.)
The resulting formula was applied.
=IF(AND(HOUR(H19)>=4,(J19)="No",1,IF(AND(HOUR(H19)>=4,(I19)="Yes"),0.5,IF(AND(HOUR(H19)>=2,HOUR(H19)<4),0.5,0)))
No comments:
Post a Comment