Forum Discussion

safoine's avatar
safoine
Copper Contributor
Apr 24, 2021
Solved

conditional 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
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 24, 2021

    safoine 

    That's rounding error. You may use

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

    or like instead.

Resources