Page 1 of 1

IIF formula

Posted: Thu Apr 28, 2016 9:44 pm
by laducd
{IIF(cq1.TradeDescription=="CAPITAL LEASE",(cq1.Pre_Swap_Debt_Total/Capital_Lease.Post_Swap_Debt_Total_Sum)*cq1.Post_Total_IRS_Rate2)}

Is there anything wrong with this if formula

Re: IIF formula

Posted: Thu Apr 28, 2016 10:14 pm
by Jan
Hello,

You skip the third argument of IIF function. What you need:

{IIF(condition, variant1, variant2)}

You have only variant1.

Thank you.

Re: IIF formula

Posted: Wed May 11, 2016 5:17 pm
by laducd
can you jump on a call

Re: IIF formula

Posted: Thu May 12, 2016 7:42 am
by HighAley
Hello.

Do you have any issue with IIF() function?
Please, write us to support@stimulsoft.com.

Thank you.