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.