I’ve been struggling to figure out how to type in this IF function for excel. I could really use some help! Thank you!!
On the Imaging Staff worksheet in cell G2, create a formula using the IF function and structured references to create a calculated column that determines the value of Weeks Vacation based on the following criteria:
a. If the years employed are less than 3, the Weeks Vacation should be 2
b. If the years employed are 3 or more, the Weeks Vacation should be 3
I keep getting invalid credentials or the outcomes being all FALSE, TRUE and 0, all the cells being 0, or the first 3 cells being 0 and the last 3 coming out as NULL instead of the correct numbers… The correct answers when the formula is entered correctly is:
G2:3
G3:2
G4:3
G5:2
G6:3
G7:3
I attached the excel file if that helps. Thanks again!
Bookmarks