Skip to Content
0
Former Member
Jan 11, 2011 at 09:31 AM

Xcelsius Engage Server bug with IF() function.

29 Views

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?