Amalgamating another IF statement

[ddub25]

I have this formula below, but can anyone help me to adapt it further to add another condition so that the overall formula reads:

=IF(E22<>"Paul",0,IF(OR(D22="Chris W",D22="Dan W",D22="Dunc M",D22="Em H",D22="Jack J",D22="Jill W",D22="Rich W",D22="Sal W",D22="Stew F",D22="Tim W"),X22*$AA$28,0))

but IF all the conditions are met above AND AA22>0, calculate (X22*AA22) INSTEAD, IF NOT return 0.

Thanks in advance.

Dan

[DonkeyOte]

To be honest the requirements aren't crystal clear... I think perhaps you're asking for:

Please Login or Register  to view this content.