New to function. Need help with "IF" condition

F

FISH

How can I add something to a function to where if a certain cell (that would
be involved in that function) is blank, the result will be blank no matter
what?



For example:

Let's say I have a function in I14 that adds F10-F14. Right now, if F14 is
blank the results will still show in I14. How can I add something to the
function in I14 that if F14 is left blank, I14 will also be blank no matter
what is entered in the rest of the cells involved in the function (F10-F13
in this example)?



Thanks.
 
F

FISH

Yes, I just didn't understand how to use it. Sorry if this seems like a
simple question to most of you.
 
F

FISH

Let me be more specific:

I have this lengthy function in the cell K15:

=IF(H15 > 0, IF(COUNTIF(H:H,">0")*$G$6<$G$5,$G$6
+H15/SUM(H:H)*($G$5-COUNTIF(H:H,">0")*$G$6),H15/SUM(H:H)*$G$5),0)+G6

I want to make sure the result in K15 remains blank if nothing is entered
into the cell H15. If anything at all is entered into H15, then I want the
function to be performed and show the results in K15.


Thanks in advance for any help.
 
J

JE McGimpsey

One way:

=IF(H15="","",IF(...

FISH said:
Let me be more specific:

I have this lengthy function in the cell K15:

=IF(H15 > 0, IF(COUNTIF(H:H,">0")*$G$6<$G$5,$G$6
+H15/SUM(H:H)*($G$5-COUNTIF(H:H,">0")*$G$6),H15/SUM(H:H)*$G$5),0)+G6

I want to make sure the result in K15 remains blank if nothing is entered
into the cell H15. If anything at all is entered into H15, then I want the
function to be performed and show the results in K15.


Thanks in advance for any help.
Click to expand...
 
F

FISH

Thank you. I'm pretty weak on this stuff so where would I add that into my
spreadsheet?

And what exactly would I add? The entire exact

=IF(H15=","",IF(...

Or leave out the ...
Or leave out the (...


Sorry for the ignorance.
 
J

JE McGimpsey

Try:

=IF(H15="","",IF(H15 > 0, IF(COUNTIF(H:H,">0")*$G$6<$G$5,$G$6
+H15/SUM(H:H)*($G$5-COUNTIF(H:H,">0")*$G$6),H15/SUM(H:H)*$G$5),0)+G6)
 
Top