Forum Discussion
Help with IF function
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 emp...
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.