# Need help with complex formula

1. ## Need help with complex formula

Hello All,

I need help with formula.

Here is the example what I want to achieve

=IF A2=Sheet5!C4 and D2="M" than F2*Sheet5!E4
But I need insert more conditions. Like, if D2 will be S (instead of M) than F2*Sheet5!E6 and if D2 will be N than F2*Sheet5!E7 and etc.

2. ## Re: Need help with complex formula

Formula:
`Please Login or Register  to view this content.`

3. ## Re: Need help with complex formula

Thanks a lot!

4. ## Re: Need help with complex formula

You're welcome & thanks for the feedback.

5. ## Re: Need help with complex formula

just one more thing... on the sheet2 there are two different ID's. According to them I need to calculate different %.
For example. if A2=Sheet2!C10 (and C10 has different ID) it should make different calculation.

I have updated attached file.

You really helping me

6. ## Re: Need help with complex formula

in this case this should work right? => =IF(A2=Sheet2!C4,INDEX(Sheet2!E4:E7,MATCH(D2,Sheet2!D4:D7,0))*F2,IF(A2=Sheet2!C10,INDEX(Sheet2!E10:E13,MATCH(D2,Sheet2!D10:D13,0))*F2,))

7. ## Re: Need help with complex formula

Looks good, have you tried it?

There are currently 1 users browsing this thread. (0 members and 1 guests)