Removing False Value

Solved/Closed
danmanuele - Mar 29, 2017 at 03:06 PM
 Blocked Profile - Mar 30, 2017 at 04:41 PM
Hello,

I would like to know how to remove the "False" Value when if function is nested. Here is an Example


=IF(G23=0,P15/Sum(D11:F11,IF(G23>0,P15/Sum(D11:G11))))

anytime G23 is greater than 0 I get False

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
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
-1
danmanuele Posts 2 Registration date Wednesday March 29, 2017 Status Member Last seen March 29, 2017
Mar 29, 2017 at 05:23 PM
Thank you!
0
Blocked Profile
Mar 30, 2017 at 04:41 PM
Great minds sir! You beat me to it by 2 minutes! LOL!
0