How to add 2 conditions to a Formula or modify existing formula

Hi
I'm trying to add either a new condition to a formula or modify existing formula, so blank cells can't be taken as a number like 0
Here is the formula =IF(N14>0,1,0)

***This is what I do with formulas with similar problems =IF(COUNT(Y14,A14)=2,Y14/A14*100,"") unfortunately the above condition its already a condition by itself so I don't know what to do whether to modify condition or add a new condition which I don't know how to do.

Thank you very much

Frank

Unless I've misunderstood, all you need is to use COUNTA instead of COUNT:

=IF(COUNTA(Y14,A14)=2,Y14/A14*100,"")

Thanks for your reply Andrew but the condition I need help with is =IF(N14>0,1,0) the one below is just an example when I deal with formulas only..
Sorry I should've explained myself better I meant to say condition not formula (I'm trying to add either a new condition to a formula or modify existing formula)

Thanks

So what you want if your =IF(N14>0,1,0) not to count blank cells as being zero, is that correct?

yes

Thanks A lot andrew

OK, so what do you want it to return if it finds that the target cell is a blank?

I think what you're probably after here is something along the lines of:

=IF(ISBLANK(N14),"Something",IF(N14>0,1,0))

Sorry still shows the value even thought there was a blank cell,
I can give you access with a link if you don't mind

Thanks for the effort Andrew

OK, maybe:

=IF(TRIM(N14)="","Something",IF(N14>0,1,0))

It works, Thanks A lot Andrew
The only thing now there's Something in the cell instead of blank, and because I have another formula after that =X15+Y14 there is an error (error: not a number: something )

Thanks

I figured out Andrew, all I did was erase something and it worked perfect
Thanks A lot your the best