Help with IF function

New Contributor

I am trying to create a spreadsheet to track allowed vacation time for employees. I would like column F to contain a formula that will return the correct number of vacation days for an individual employee based on position and years of service. My parameters are in I:K. 




3 Replies


You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.


help with if formula.JPG 

This does not work. It returns "#N/A". Also, ctrl+shift+enter does nothing. 


Does ctrl+shift+enter add the curly brackets (highlighted in the screenshot) to the formula? You can click in the formula bar with the mouse and then confirm the formula with ctrl+shift+enter. This adds the " { " and " } " and then the arrayformula returns the result.

curly brackets.JPG