Conditions between two values
Solved
Bourlamaque
Posted messages
1
Status
Member
-
Bourlamaque -
Bourlamaque -
Hello,
I need a formula for the following situation: if, in my cell (B3), the total hours worked are between 8 and 13.75, I want to display "package" and if the total is between 14 and 16.75, I want to display "long".
For now, I have to use 2 columns, but I would like everything to be in the same cell.
Can someone help me?
I need a formula for the following situation: if, in my cell (B3), the total hours worked are between 8 and 13.75, I want to display "package" and if the total is between 14 and 16.75, I want to display "long".
For now, I have to use 2 columns, but I would like everything to be in the same cell.
Can someone help me?
7 answers
Sure, no problem! No issue with the gap between 13.75 and 14, those are hours so according to my needs, the employee is rounded to the quarter hour.
However, where do I insert my condition of =IF(B3<=4,4)? Because if the employee works less than 4 hours, they are still paid for 4 hours...
When I try to insert it, it gives me an error message.
And no, I won't add any other conditions!!!! :)
However, where do I insert my condition of =IF(B3<=4,4)? Because if the employee works less than 4 hours, they are still paid for 4 hours...
When I try to insert it, it gives me an error message.
And no, I won't add any other conditions!!!! :)
