Function HELP!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This function: =IF(W11=0," ",IF(X11=0," ",IF(Results!C5=0," ",(W11+X11)-Results!C5)*24*60)) current returns a #Value! error when it returns an empty " ", Id like for it the return a 0 instead if there is nothing greater than 0 to return. Is this possible, if so how

Thanks,
 
Well, " " is not empty, it's a space. "" is slighty more empty, so try
changing your formula(s) to "" and see if that helps.



Terri said:
This function: =IF(W11=0," ",IF(X11=0," ",IF(Results!C5=0,"
Click to expand...
",(W11+X11)-Results!C5)*24*60)) current returns a #Value! error when it
returns an empty " ", Id like for it the return a 0 instead if there is
nothing greater than 0 to return. Is this possible, if so how?
 
Or maybe 0 instead of ""
Dave R. said:
Well, " " is not empty, it's a space. "" is slighty more empty, so try
changing your formula(s) to "" and see if that helps.




",(W11+X11)-Results!C5)*24*60)) current returns a #Value! error when it
returns an empty " ", Id like for it the return a 0 instead if there is
nothing greater than 0 to return. Is this possible, if so how?
Click to expand...
 
Dave

No it does not, just tried it. What I need is a zero "0", if there is nothing to return

Thanks,

----- Dave R. wrote: ----

Well, " " is not empty, it's a space. "" is slighty more empty, so tr
changing your formula(s) to "" and see if that helps



Terri said:
This function: =IF(W11=0," ",IF(X11=0," ",IF(Results!C5=0,
Click to expand...
",(W11+X11)-Results!C5)*24*60)) current returns a #Value! error when i
returns an empty " ", Id like for it the return a 0 instead if there i
nothing greater than 0 to return. Is this possible, if so how
 
Ok the problem appears to be that W11, X11 or results!c5 is not a number (I
guess it's a space..).

If you just want to get around the #value! error, try

=IF(ISERROR(paste formula here),0,paste formula here)
 
Back
Top