=$C2-$B2<5 will return FALSE or TRUE depending on the value of B2, not on the difference between B2 and C2
You should use parenthesis![]()
=($C2-$B2)<5
=$C2-$B2<5 will return FALSE or TRUE depending on the value of B2, not on the difference between B2 and C2
You should use parenthesis![]()
=($C2-$B2)<5
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks