I will try to explain this, and hopefully it will make sense ;-)
I got a building building height left and a building height right. Since they are delivered from Lidar, those are not completely equal, but can vary with 0.3 m for a gable roof. What I would like to do is to get the color “red” if left and right minus each other has a range from -0.3 to 0.3
In Ecxel it could look like this:
=IF(AND(Left-Right>=-0.3; Left-Right <=0.3);"Yes"; "Shape") So this brings a Yes if my calculation is between -0.3 and 0.3.