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
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
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
Related:
- Removing false statement
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- Removing redirect virus - Guide
- Remove false from if statement ✓ - Office Software Forum
- Removing false in excel ✓ - Excel Forum
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
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
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