safoineCopper ContributorApr 24, 2021Solvedconditional formatting Hello Please why when (ps+pw)/1.4=2000 the green icon doesn't appear ? the condition pc>=(ps+pw)/1.4 when I try it with numbers not equation, it's working well Show More2.jpg108 KB1.jpg229 KBSergeiBaklan to safoineApr 24, 2021safoine That's rounding error. You may use =ROUND((B2+B3)/1.4,6) or like instead.
SergeiBaklan to safoineApr 24, 2021safoine That's rounding error. You may use =ROUND((B2+B3)/1.4,6) or like instead.
SergeiBaklan to safoineApr 24, 2021safoine That's rounding error. You may use =ROUND((B2+B3)/1.4,6) or like instead.
SergeiBaklanDiamond Contributor to safoineApr 24, 2021safoine That's rounding error. You may use =ROUND((B2+B3)/1.4,6) or like instead.
