driftmachine888
New member
- Joined
- Nov 27, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi Guys! Good day!
I was ask to make a formula to compute for the holiday hours rendered here in our company..
In the column 1 you are only allowed to input numbers between 1 - 8 (which represents 1 hr to 8 hrs of work)
In the column 2 you can only input a data if you have 8 or more in the column 1. If you have less than 8 in the column 1 you are not allowed to input any data on column 2 (column 2 represents overtime hrs in excess of the 8 hrs required)
please help me guys how to go about my problem.
Thank you so much!
Example:
I was ask to make a formula to compute for the holiday hours rendered here in our company..
In the column 1 you are only allowed to input numbers between 1 - 8 (which represents 1 hr to 8 hrs of work)
In the column 2 you can only input a data if you have 8 or more in the column 1. If you have less than 8 in the column 1 you are not allowed to input any data on column 2 (column 2 represents overtime hrs in excess of the 8 hrs required)
please help me guys how to go about my problem.
Thank you so much!
Example:
Column 1 | Column 2 |
7 | |
8 | |
8 | 1 |
8 | 2 |
:Cry: