1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Remove 'false" cell is empty

    From Alex Hime@21:1/5 to All on Sat Feb 5 18:06:30 2022
    I have 2 cells and in one I will have a number (1,2,3...) and I want the 2nd cell to say "Term". To show how many Terminations are that day. I was able to show Term when a number is entered, but when it is empty it says "false". How do I hide the false
    if there is no number without adding 0 or changing text color?

    This is the formula I am using
    =if(OR (G5=1,G5=2,G5=3,G5=4,G5=5,G5=6,G5=7,G5=8,G5=9), "Term")

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Sun Feb 6 09:39:55 2022
    Hi Alex,

    Am Sat, 5 Feb 2022 18:06:30 -0800 (PST) schrieb Alex Hime:

    I have 2 cells and in one I will have a number (1,2,3...) and I want the 2nd cell to say "Term". To show how many Terminations are that day. I was able to show Term when a number is entered, but when it is empty it says "false". How do I hide the
    false if there is no number without adding 0 or changing text color?

    This is the formula I am using
    =if(OR (G5=1,G5=2,G5=3,G5=4,G5=5,G5=6,G5=7,G5=8,G5=9), "Term")

    try:
    =IF(AND(G5>0,G5<=9,MOD(G5,1)=0),"Term","")

    Regards
    Claus B.
    --
    Windows10
    Microsoft 365 for business

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)