将嵌套IF Excel语句转换为SQL

Question

有人能帮我把这个嵌套的IF公式在Excel转换成一个CASE语句(或任何更有效的)在SQL?:

=IF(B11="",IF(OR(R11="STORY.COM",R11="EXPERIENCE"),FALSE,IF(AE11="Yes",TRUE,IF(AE11="Unknown",IF(D11="",IF(E11="",FALSE,E11),D11),FALSE))),B11)

提前谢谢你

Answer 1

如果你从左到右滚动并输入case.. when.. then.. else..end，你将最终得到以下内容:

case when B11 = ''
then case when R11 = 'STORY.COM' or R11 = 'EXPERIENCE'
then 'False'
else
case when AE11='Yes'
then 'True'
else
case when AE11='Unknown'
then case when D11=''
then case when E11=''
then 'False'
else E11 end
else D11 end
else
'False' end end end
else
B11 end