5 Replies Latest reply on May 8, 2012 5:18 AM by lewis.manley

    How do I construct a "where/if" calculation?

      Hi all,


      I am trying to create a calculated field which will essentially create a rental yield by area.

      The calculation in laymans terms is the ((averageprice when rent)*12)/(averageprice when sale) I have attached a packaged workbook with sample data to help.


      Any ideas all?