Assistance Adding a Statement to this Formula

[thewiseguy]

Hello everyone - I am currently using the following formula:

=IF(W7="YES",W8,IF(AND(W7="",Dashboard!J17="PSEG"),'Lighting&Controls(PSEGrebates)'!E1,'Lighting&Controls (JCPLRebates)'!A1))

I would like to add the following statement to it:

=If(Dashboard!J17=anything other than PSEG or JCPL, then Lighting&Controls (OtherRebates)'!A1

Hope that is clear and thank you in advance!!

 

[GuzmanServices]

Please let us know if the following formula works for the above scenario:

=IF(W7="YES",W8,IF(AND(W7="",Dashboard!J17="PSEG"),'Lighting&Controls(PSEGrebates)'!E1,IF(AND(Dashboard!J17<>"JCPL",Dashboard!J17<>"PSEG"),'Lighting&Controls(OtherRebates)'!A1,'Lighting&Controls (JCPLRebates)'!A1)))

 

[thewiseguy]

Please let us know if the following formula works for the above scenario:

=IF(W7="YES",W8,IF(AND(W7="",Dashboard!J17="PSEG"),'Lighting&Controls(PSEGrebates)'!E1,IF(AND(Dashboard!J17<>"JCPL",Dashboard!J17<>"PSEG"),'Lighting&Controls(OtherRebates)'!A1,'Lighting&Controls (JCPLRebates)'!A1)))

this is perfect, thank you so much