Removing false statement

Closed
Formula - Jul 14, 2016 at 09:40 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 14, 2016 at 07:55 PM
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 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 14, 2016 at 07:55 PM
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
0