google-sheets - Google Spreadsheet Conditional Formatting with another Cell Value from Queries

Question

So I have this formula:

=if(D7>=D5,"PROFIT", IF(D7<=D6,"LOSS", "ACTIVE"))

and as you can see in the picture the value of D7 is not >=D5 and not <=D6 but the formula in D9 keeps giving me value LOSS which is not true. I was expecting to give value "ACTIVE".

Data in D6 and D5 are parsed with the query. Data in D7 is parsed with importxml.

Could you help me with this? Thank you

标签： google-sheets

Answer 1

我的查询有问题。我不知道为什么，但是查询“order by A desc LIMIT 10, 1”的这一部分打破了我的公式。我删除了这部分，只留下了“=query（App！A1：K，”select B“”和它工作得很好。如果有人可以帮助解释为什么这个添加会影响我的公式，那将会有很大帮助。