Trying to make a IF AND OR function work

Hi,
I am trying to make an IF AND OR function work but cant work it out. Please Help

IF cell AQ8=5 AND cell AR8="Y" I want to return the sum(BJ4*BE8)

OR

IF cell AQ8=6 AND cell AR8="Y" I want to return the sum(BJ5*BE8)

IF both are FALSE I want to return ""

probably simple but I've been going round in circles for 3 hours.

many thanks

JoJo

Try this:

=IF(AND(AQ8=5,AR8="Y"),BJ4*BE8,IF(AND(AQ8=6,AR8="Y"),BJ5*BE8,""))

Hope this helps.

Pete

You are my hero Pete.

I was going crazy.

Jojo