Help with adding a condition to this IF AND statement

[thewiseguy]

Hi everyone,

I currently am using this IF AND statement:

=IF(AND(V5="NO",'Dashboard (input)'!I16="PSEG"),'Lighting&Controls(PSEGrebates)'!B2,'Lighting&Controls (JCPLRebates)'!A1)

I would like to add another condition which would be:

IF V5="Yes" then V6

Any help is greatly appreciated!!

 

[Fluff]

Maybe

=IF(V5="YES",V6,IF(AND(V5="NO",'Dashboard (input)'!I16="PSEG"),'Lighting&Controls(PSEGrebates)'!B2,'Lighting&Controls (JCPLRebates)'!A1))

 

[thewiseguy]

as always Fluff, thank you!

 

[Fluff]

My Pleasure.