Removing False Value
Solved/Closed
Related:
- Remove false from if statement
- How to remove story from close friends - Instagram Forum
- Remove ads from gmail - Guide
- Remove search baron from mac - Guide
- Remove wga - Download - Cleaning and optimization
- Fenix internet on bank statement - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
29 Mar 2017 à 16:29
29 Mar 2017 à 16:29
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
29 Mar 2017 à 17:23
30 Mar 2017 à 16:41