Need help writing a formula
 

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€�

Need help writing a formula
 

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

If this post helps click Yes
---------------
Jacob Skaria


"lakwriter" wrote:

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€�

Need help writing a formula
 

=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"))

lakwriter wrote:

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€�

--

Dave Peterson

Need help writing a formula
 

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
---
"lakwriter" wrote:
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€�