Removing false statement

[Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
Hello,
I would like to remove a FALSE statement, want it to show nothing.

My formula is as follow =IF(A23=1,G23,IF(A23=2,G23,IF(A23=3,G23,IF(A23=4,G23,IF(A23=5,G23,IF(A23=6,G23))))))
If true, I want numbers to be with comma format (0,000) if false I want to to show a blank cell, no zero number.

Thanks

1 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
Formula, Good evening.

You can use it:

=IF(OR(A23={1,2,3,4,5,6}), G23, " ")

Format cell with formula as NUMBER / 5 DECIMALS

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão