Using if and ifblank

[Willway22]

Hi Everyone,

I've been trying a number of different combinations but nothing is working so far. I am trying to do a formula that if a cell is blank then to do a sum. The "sum" part works fine:

=IF(G3>3,"yes","no")

but what I can't do if for it to only perform the sum where the cell is blank (so to not perform the formula if there is a number already in the cell). This is what I have:

=IF(ISBLANK(I11),(I3>3,"yes","no"))

I've looked at a lot of formulas online, but I can't quite make it work. Is anyone able to help?

Thank you so much.

 

[kevin9999]

=IF(ISBLANK(I11),IF(I3>3,"Yes","No"))

 

[Peter_SSs]

Welcome to the MrExcel board!

You also need to allow for if I11 is not blank

=IF(ISBLANK(I11),IF(I3>3,"Yes","No"),"")

.. though I would usually go for the shorter

=IF(I11="",IF(I3>3,"Yes","No"),"")

 

[Willway22]

Thank you so much for your reply. When I do this it returns the result '0'- rather than yes or no.
And if I drag the formula over cells that have data already in, it also changes that to '0'. Is there a way around this?

 

[jakel27]

I'm not sure if I understand your problem properly but I always find ISBLANK annoying, because even if the cell is blank but has a formula such as ="", then it says the cell is NOT blank. I.e. it actually has a value in it.

I tend to use the IF statement <>"" being, if the cell is not equal to anything (blank), then... "yes" and if it is equal to anything (>0), then "no"

=IF(E5<>"","yes","no")

so for you

=IF(I11<>"",IF(I3>3,"yes","no"),"")

 

[Peter_SSs]

Thank you so much for your reply. When I do this it returns the result '0'- rather than yes or no.

Two people have responded with three formula suggestions so who and which formula are you referring to?
There is nothing in any formula suggested prior to your post that would return a 0.