I'm trying to do a formula that shows the text "Tickets" or "Live chat" depending on an even or odd week number.
I have done the formula
=IF(ISEVEN(B5), "Live Chat", "Tickets")
This produces the text that I want but where there's no data in the week number column, it produces the error '#VALUE!'
I changed the formula to
=IF(B10="","",OR(ISEVEN(B10), "Live Chat", "Tickets"))
This produces an empty field where there's no data in the week number column but once the data is entered, it only produces the text 'TRUE' or 'FALSE' - I need to find a way to combine the two formulas so that the 'Live Chat' and 'Tickets' text is produced when data is entered but it remains blank when no data
