Can you send an IF statement to an Excel cell from QlikView?

[#1]

Hi, I am trying to find a way of exporting data from QlikView into an Excel spreadsheet with IF statements pasted into certain cells. I would have thought that QlikView could handle this, as it does with SUMs, text, numbers, etc. but it appears not to work. Does anybody have any experience of this, and hopefully an answer?

The code that I am trying to send goes along these lines:

XLSheet.Range("B11")="=IF(A11<>"",(B48+B61)/SUM(B22:E22),"")"

As I say, the SUMs code works fine, as in:

XLSheet.Range("B96")="=SUM(B89:B95)-L56"

There are reasons why this needs to be done in Excel rather than in QlikView, basically the number of records that I deal with here at DTCC are far more than Excel can handle, which is why I use QlikView, but the IF statement not copying across has been a problem.

Thanks,

Steve.

[m_woolf]

The problem is that the formula string contains double quotes:

XLSheet.Range("B11")="=IF(A11<>"",(B48+B61)/SUM(B22:E22),"")"

Try something like this:

XLSheet.Range("B11")="=IF(A11<>"""",(B48+B61)/SUM(B22:E22),"""")"

[#3]

THANKS SO MUCH!!!! You have saved my skin!!!!

[m_woolf]

I'm glad I could help.

If you are satisfied with the answer, please mark it as Correct.