LinkBack URL
About LinkBacks
tomribeiropereira 
It can be blank, because are results of other equation.
Need to skip 0. Thanks.
It can be blank, because are results of other equation.
Need to skip 0. Thanks.
You could change the the equation can return a null string instead of a 0.
Or use
=median(if(a1:a5<>0, a1:a5))
... confirmed with Ctrl+Shift+Enter.
Entia non sunt multiplicanda sine necessitate
Hi, shg, thank for you help.
The equation before that give me the result that are entered in the MED column is:
=U55(T55*6.3)*10
How this equation can give me null sign? Or zero sign?
After that, if it give me null sign the function MED will work correctly i suppose, right?
And if it give me Zero sign, how can MED function ignore Zero numbers?
If one of this works it´s solve the problem. Thanks again.
Last edited by tomribeiropereira; 03-02-2011 at 06:02 PM.
=if(t55*u55=0, "", t55*u55*6.3*10)
You just save me man, thanks very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks