Removing False Value [Solved/Closed]

Report
-
 Blocked Profile -
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 replies

Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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
Posts
2
Registration date
Wednesday March 29, 2017
Status
Member
Last seen
March 29, 2017

Thank you!
Blocked Profile
Great minds sir! You beat me to it by 2 minutes! LOL!

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!")
Posts
2
Registration date
Wednesday March 29, 2017
Status
Member
Last seen
March 29, 2017

Thank you!!