Error in Excel???... Maybe

  • Thread starter Thread starter Bill
  • Start date Start date
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?
 
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",""))
 
Back
Top