Removing false statement

Closed
Formula - 14 Jul 2016 à 09:40
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 14 Jul 2016 à 19:55
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 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
14 Jul 2016 à 19:55
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