SOLVED

conditional formatting

Occasional Contributor

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

2 Replies

@safoine 

safoine_0-1619279469999.pngsafoine_1-1619279495107.png

 

best response confirmed by safoine (Occasional Contributor)
Solution

@safoine 

That's rounding error. You may use

=ROUND((B2+B3)/1.4,6)

or like instead.