Hello.
I find out bug with IF() statment.
I have formula =IF(B15>C15, "red", "#a3c5ec") depending on values it should change cell what i use to background color.
If i put values like B15 = 0.5, C15 = 0.01 or B15 = 0,5, C15 = 0,01 then IF statment work as it should work.
But bug is shows then value to cell B15 (for example) will come from some other sourse. So if
B15 = Line1!C1 and Line1!C1 is same 0.5 value... then IF will not recognize what.
Does enyone alse have what problem before?