Error in Excel???... Maybe

B

Bill

I cannot get multiple if statements to register text
values... example
=IF(K3=0,"Not Ready","") in my target cell will show NOT
READY if k3=0
but...
=IF(K3=0,"Not Ready",""),(IF(L3=0,"Not Available","")) in
my target cell will show #value! instead of the NOT
READY, if i replace the text in the formula with numbers
it will work

Is this a error or am I totally overlooking something?
 
F

Frank Kabel

Hi
what do you want to achieve? First test K3 and if this is not zero test
L3. if yes you may try
=IF(K3=0,"Not Ready,IF(L3=0,"Not Available",""))
 

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

Need greater than = .. less than = combined with index/match state 6
Simple if, if ? 6
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
Re-post Formula 2
DIV error 1
Value of minutes not calculated 8
show current value 1
Figuring total # of hours between multiple times 5

Top