Search results

You're right. I did put the wrong equations in my original post. Sorry for the confusion. :) Anyways, I tried your suggestion and it worked! :) Thank you so much for your help. You saved me a lot of time of aggregation and confusion. Thanks again. Melissa

Well I have 3 different equations for 3 different time periods. Before 10/31/02, I want to use this equation: [WAPA Net]-([Med Bow 8]+[Med Bow 9])*[City Loss]+[City Energy Adj] Between 11/01/02 and 10/31/06, I want to use this equation: [WAPA Out]-([Med Bow 8]*[City Loss])-[Clipper...

I currently have an IIF Statement that looks like this: City Energy: IIf([Tbl-Input Data]![Billing Month]<=37560,[WAPA Net]-([Med Bow 8]+[Med Bow 9])*[City Loss]+[City Energy Adj],[WAPA Out]-([Med Bow 8]*[City Loss])-[Clipper Energy]+[City Energy Adj]) Now I need to add after October 31...