excel - Formula only if formula result = >.001 -
trying format cell (throughout entire column) if formula result of same cell returns value of >.001 in other words, if result 0, nothing entered cell.
the comment work. way suppose desired formula a2-b2 (you testing whether things meaningfully different). using criterion (leaving aside whether might more meaningful absolute value must exceed .001), rewrite formula as:
=if(a2-b2>0.001,a2-b2,"")
this generalize formula.
Comments
Post a Comment