Removing False Value [Solved/Closed]

danmanuele - Mar 29, 2017 at 03:06 PM - Latest reply: ac3mark 10525 Posts Monday June 3, 2013Registration dateModeratorStatus September 21, 2018 Last seen
- 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 

5 replies

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Mar 29, 2017 at 04:29 PM
-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 2 Posts Wednesday March 29, 2017Registration date March 29, 2017 Last seen - Mar 29, 2017 at 05:23 PM
Thank you!
ac3mark 10525 Posts Monday June 3, 2013Registration dateModeratorStatus September 21, 2018 Last seen - Mar 30, 2017 at 04:41 PM
Great minds sir! You beat me to it by 2 minutes! LOL!
ac3mark 10525 Posts Monday June 3, 2013Registration dateModeratorStatus September 21, 2018 Last seen - Mar 29, 2017 at 04:31 PM
-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 2 Posts Wednesday March 29, 2017Registration date March 29, 2017 Last seen - Mar 29, 2017 at 05:24 PM
Thank you!!