Report

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
See more 
Helpful
+1
plus moins
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!")
Was this answer helpful?  
danmanuele 2Posts Wednesday March 29, 2017Registration date March 29, 2017 Last seen - Mar 29, 2017 at 05:24 PM
Thank you!!
Reply
Leave a comment
Helpful
-1
plus moins
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 - Mar 29, 2017 at 05:23 PM
Thank you!
Reply
ac3mark 7105Posts Monday June 3, 2013Registration date ModeratorStatus June 23, 2017 Last seen - Mar 30, 2017 at 04:41 PM
Great minds sir! You beat me to it by 2 minutes! LOL!
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!