IF AND OR Statement

[Cammandk]

I just can't get this to be excepted. Brain blank

If I19 = "E" and V19 = "U" or "P" then U19 otherwise 0

=IF(AND($I19="E",IF(OR($V19="U",$V19="P"),$U19,0)

Thanks
DK

 

[Smallman]

CammandK

You are almost there;

=IF(AND($I19="E",OR($V19={"U","P"})),$U19,0)

or

=IF(AND($I19="E",OR($V19="U",$V19="P")),$U19,0)

Take care

Smallman

 

[Cammandk]

Thanks Smallman [SOLVED]

 

[Smallman]

No worries CammandK. Glad you got over the line.

Smallman