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)