AnsweredAssumed Answered

How do I calculate a value between two object attributes within a range

Question asked by KennethLinformi-dk-esridist Employee on Oct 2, 2014
Latest reply on Oct 12, 2014 by KennethLinformi-dk-esridist

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.   

Outcomes