Need help writing a formula

L

lakwriter

I am having difficulty writing a formula and hope that someone can help me.
I've written out the formula below and need to put it in the correct Excel
syntax.

If L4 = “Insufficient Data†return “Insufficient Data†AND If J4 and K4 both
= 0, then return “no needâ€
 
J

Jacob Skaria

Try
=IF(L4="Insufficient Data",L4,IF(AND(J4=0,K4=0,J4<>"",K4<>""),"No need",""))

If this post helps click Yes
 
D

Dave Peterson

=if(L4="insufficient data",L4,if(and(j4=0,k4=0),"no need","whatgoeshere"))

If j4 and k4 are empty, then excel treats them as 0's. Is that a problem?

If it is, then maybe:
=IF(L4="insufficient data",L4,IF(Countif(J4:K4,0)=2,"no need","whatgoeshere"))
 
M

Max

One thought:

=IF(L4="Insufficient Data","Insufficient
Data",IF(AND(COUNT(J4:K4)=2,J4=0,K4=0),"no need",""))

For completeness, the above presumes you need to check that J4 and K4 do
contain zeros (as blank cells will be evaluated in formulas as being equal to
zeros). It also presumes that if none of the 2 conditions checked is TRUE,
then the formula is simply to return a blank: "". Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top