Need help writing a formula

  • Thread starter Thread starter lakwriter
  • Start date Start date
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â€
 
Try
=IF(L4="Insufficient Data",L4,IF(AND(J4=0,K4=0,J4<>"",K4<>""),"No need",""))

If this post helps click Yes
 
=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"))
 
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
 
Back
Top