Share
Report
2Hi All,
Hoping to find some help here. I am fairly proficient writing formulas in excel, however, I now use PQE a lot. I am looking to replicate work I have done previously in excel, using only excel, by incorporating PQE to manage most of the work for me. I am slowly making ground with PQE syntax but I am yet to understand how to stack formulas and how to perform SUMS within a formula. An example of one of my excel formulas, which I wish to replicate in PQE is below. Could somebody perhaps translate this to a working PQE formula, from which I can start to understand the structure and workings of PQE formulas.
=IF(AND([@[Rent Review Date]]<Months!$B$1,[@[Rent Review Date]]>Months!$A$1),SUM([@[Previous Rent]]/12)+SUM([@[New Rent]]-[@[Previous Rent]])/366*[@[New Days]],IF([@[Review Date]]>Months!$B$1,SUM([@[Previous Rent]]/12),[@[New Rent]]/12))
I use this to determine what value of rent is due in a month based on whether or not an increase occurs in the given month. All of the data in PQE mirrors column names, tab references etc.
Thanks in advance.
All responses (
Answers (
