Forum Discussion

Shanaya_98's avatar
Shanaya_98
Copper Contributor
Dec 24, 2023

Formulas to show blank if no data

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

Resources