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 produc...
Excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Dec 24, 2023

Shanaya_98 

Use

 

=IF(B10="", "", IF(ISEVEN(B10), "Live Chat", "Tickets"))

  • Shanaya_98's avatar
    Shanaya_98
    Copper Contributor
    Dec 24, 2023
    That's worked! Thank you so much!

Resources