Recent content by Jasper.Muduvhadzi

  1. J

    [Solved] Excel Formula= If statement of Between 2 years intervals

    Dear Yousuf, Thank you for the heads up, this looks short and to the point. However, my alternative was the below but it's a quite long. On the above i now realized i was missing 3rd logical function and the allocation of the interval in terms of changing the cycle from 5,10,15,20 etc. Many Thanks
  2. J

    [Solved] Excel Formula= If statement of Between 2 years intervals

    Dear friends, I would like to ask foo the assistance on the method of calculating the below question. > It goes like this. Calculate Three (3) times the average monthly salary for the employee having between Five (5) and ten (10) years of service with the company. I have tried to calculate...
  3. J

    [Solved] General Question About Filtering

    Thats is the problem, my property does not have unblock box
  4. J

    [Solved] Excel VBA - Rearranging the data into a report format

    My VBA is Disabled. Any one who knows how to enable Macros here. I have tried to enable it on trust center but still getting the message showing that Microsoft has disabled my macro.
  5. J

    [Solved] General Question About Filtering

    Hello Guys, Anyone who knows how to enabled macros VBA Received message that says that Microsoft has disabled my macros even if i can try to enable them i still see the same error message. Please help
  6. J

    [Solved] Excel Query- Percentages calculations

    Dear Shamimarita, Thanks, you for your feedback. However, i still have some question. See below: How do you see who has completed 40 hours from your work? All I see is Count of affected staff / total staff. And when you format those percentages from question 1 and 2, all of them they give you...
  7. J

    [Solved] Excel Query- Percentages calculations

    Hello everyone, I need some assistance. 1. How do we calculate the Average percentage for Overtime units? Note that in the whole headcount, only a few employees were counted for those overtime units. working File is attached. 2. Percentage for hours worked. Note that all employees worked...

Online statistics

Members online
0
Guests online
16
Total visitors
16

Forum statistics

Threads
303
Messages
1,331
Members
550
Latest member
JasonRip
Top