Hello
I am trying to complete a formula for the following
I want to check that if the value in NMI MIRN State says VIC OR NSW OR QLD then the value in Annual Peak KWh needs to be greater than 100000 or IF NMI MIRN State says NSW or SA then the value in Annual Peak KWh needs to be greater than 160000
This is for each row
Any help appreciated
[TABLE="class: grid, width: 1021"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Annual Peak KWh*[/TD]
[TD]Annual Shoulder KWh*[/TD]
[TD]Annual Off Peak KWh*[/TD]
[TD]Opportunity type*[/TD]
[TD]NMI/MIRN State*[/TD]
[TD]Eligible for Pricing?[/TD]
[TD]NMI Acquisition or Renewal[/TD]
[TD]Threshold Validation[/TD]
[/TR]
[TR]
[TD="align: right"]180,000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]80000[/TD]
[TD]Acquisition[/TD]
[TD]VIC[/TD]
[TD]Not Eligible[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]180,000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]80000[/TD]
[TD]Acquisition[/TD]
[TD]VIC[/TD]
[TD]Eligible[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]200000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]60000[/TD]
[TD]Acquisition[/TD]
[TD]QLD[/TD]
[TD]Not Eligible[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]300000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]40000[/TD]
[TD]Acquisition[/TD]
[TD]SA[/TD]
[TD]Eligible[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I am trying to complete a formula for the following
I want to check that if the value in NMI MIRN State says VIC OR NSW OR QLD then the value in Annual Peak KWh needs to be greater than 100000 or IF NMI MIRN State says NSW or SA then the value in Annual Peak KWh needs to be greater than 160000
This is for each row
Any help appreciated
[TABLE="class: grid, width: 1021"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Annual Peak KWh*[/TD]
[TD]Annual Shoulder KWh*[/TD]
[TD]Annual Off Peak KWh*[/TD]
[TD]Opportunity type*[/TD]
[TD]NMI/MIRN State*[/TD]
[TD]Eligible for Pricing?[/TD]
[TD]NMI Acquisition or Renewal[/TD]
[TD]Threshold Validation[/TD]
[/TR]
[TR]
[TD="align: right"]180,000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]80000[/TD]
[TD]Acquisition[/TD]
[TD]VIC[/TD]
[TD]Not Eligible[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]180,000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]80000[/TD]
[TD]Acquisition[/TD]
[TD]VIC[/TD]
[TD]Eligible[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]200000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]60000[/TD]
[TD]Acquisition[/TD]
[TD]QLD[/TD]
[TD]Not Eligible[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]300000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]40000[/TD]
[TD]Acquisition[/TD]
[TD]SA[/TD]
[TD]Eligible[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]