G
Guest
Earlier I posted a question about ignoring zero values, Well when I posted
that it helped, I had not fully tried the suggestion with zeros and > zero
values. Well here is what I have in the cell that is giving me the problem.
=MIN(D162181,D136155,D110129,D84103,D5877,D3251,D625) many of
these cells contain a 0 (Zero) value from another formula so I cannot just
leave them blank. I tried
=MIN(If(D162181,D136155,D110129,D84103,D5877,D3251,D625>0,D162181,D136155,D110129,D84103,D5877,D3251,D625))
But that doesn't work either, any suggestions?
Thanks
that it helped, I had not fully tried the suggestion with zeros and > zero
values. Well here is what I have in the cell that is giving me the problem.
=MIN(D162181,D136155,D110129,D84103,D5877,D3251,D625) many of
these cells contain a 0 (Zero) value from another formula so I cannot just
leave them blank. I tried
=MIN(If(D162181,D136155,D110129,D84103,D5877,D3251,D625>0,D162181,D136155,D110129,D84103,D5877,D3251,D625))
But that doesn't work either, any suggestions?
Thanks