# Removing False Value [Solved]

Ask a question danmanuele - Last answered on Mar 30, 2017 at 04:41 PM by ac3mark
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
+1
So your second if doesn't say what to do if false, so it displays false!

IF(G23>0,P15/Sum(D11:G11),"HERE IS SOMETHING ELSE!")
danmanuele 2Posts Wednesday March 29, 2017Registration date March 29, 2017 Last seen -
Thank you!!
-1
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
danmanuele 2Posts Wednesday March 29, 2017Registration date March 29, 2017 Last seen -
Thank you!
ac3mark 8017Posts Monday June 3, 2013Registration date ModeratorStatus October 20, 2017 Last seen -
Great minds sir! You beat me to it by 2 minutes! LOL!