In: Accounting
If the billable hours for that individual time entry is greater than 3, set the value of the cell to "High Hours". Otherwise, set the cell equal to "Normal Hours. This is an excel worksheet. How do I set the formula for this?
Hello. Based on the information available in the question , we can answer as follows:-
= IF(X>3,"High Hours","Normal Hours")
Here, x refers to - Cell reference. For example, if the cell for which you are trying to apply is A3, then formula will read:-
=IF(A3>3,"High Hours","Normal Hours")
To explain the formula:-
We use the "IF" function to check the value of a cell for a desired value and to give us a specific result of the condition(>3) meets that criteria("High Hours). If the condition does not meet that criteria, the other option ("Normal hours") is returned.
Please let me know if you have any questions via comments and i can clarify .
Example:-
This is the result i got for applying the formula:-
And this is the screenshot of the formula that i used :-
All the best and have a nice day :)