Removing False Value
Solved/Closed
Related:
- How to remove false in excel
- Removing " false" value in "IF" ✓ - Office Software Forum
- How to take screenshot in excel - Guide
- How to remove recent files in windows 11 - Guide
- How to calculate position in excel ✓ - Office Software Forum
- Number to words in excel - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 29, 2017 at 04:29 PM
Mar 29, 2017 at 04:29 PM
danmanuele, good afternoon.
The IF function syntax is missing what to do when the clause is False.
A parenthesis is also missing by closing the first range.
=IF(G23=0, P15/Sum(D11:F11), IF(G23>0, P15/Sum(D11:G11) , What to do here when FALSE?)))
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
The IF function syntax is missing what to do when the clause is False.
A parenthesis is also missing by closing the first range.
=IF(G23=0, P15/Sum(D11:F11), IF(G23>0, P15/Sum(D11:G11) , What to do here when FALSE?)))
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mar 29, 2017 at 05:23 PM
Mar 30, 2017 at 04:41 PM