Removing False Value [Solved/Closed]

- - Latest reply: ac3mark
Posts
10932
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 11, 2018
- 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
See more 

2 replies

Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-1
Thank you
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
Posts
2
Registration date
Wednesday March 29, 2017
Last seen
March 29, 2017
-
Thank you!
ac3mark
Posts
10932
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 11, 2018
-
Great minds sir! You beat me to it by 2 minutes! LOL!
Posts
10932
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 11, 2018
-1
Thank you
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
Posts
2
Registration date
Wednesday March 29, 2017
Last seen
March 29, 2017
-
Thank you!!