SOLVED

conditional formatting

Copper 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 (Copper Contributor)
Solution

@safoine 

That's rounding error. You may use

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

or like instead.

1 best response

Accepted Solutions
best response confirmed by safoine (Copper Contributor)
Solution

@safoine 

That's rounding error. You may use

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

or like instead.

View solution in original post