Multiple if statement / run formula . Help needed

[ROD_WARRIOR]

Hi all,

I trying to find a way to improve my excel sheet and make it more automated.

Here is my question,

Let's say I have the following table where I enter my data
Capture.PNG

The value of cell D is obtained by running an sumif.
The data its going through is the following
Capture.PNG

What I am trying to do is , let's say A1 ='A' and B1=' SEMI(JOE)' , run the following formula " =500+((C1-12.5)*50))".

Can someone guide me ?

Thanks in advance for your help

[FDibbins]

To start with, that is a nice use of SUMIFS, and I guess there is no chance of having duplicate entries in DATA? However, this is a better formula to use for that...
=INDEX(DATA!$C$2:$C$13,MATCH(INPUT!A2&INPUT!B2,INDEX(DATA!$A$2:$A$13&DATA!$B$2:$B$13,0),0))

For your actual question, Im not sure where you want to put that formula, but it sounds like you want something like...
=IF(AND(A2="A",B2="semi(joe)"),500+((C2-12.5)*50),"")

[ROD_WARRIOR]

Thanks for the reply FDibbins.

What I am trying to accomplish with that formula if

Let's say

A2= "A"
B2=" SEMI(JOE)

process the equation "500+((C2-12.5)*50" and return it in D2

But I also want index or sumifs to run when the cell being compared doesn't match "A" and "SEMI(JOE).

Hope I was able to clear a little bit of the confusion.

Looking forward for your reply

[FDibbins]

OK so maybe...
=IF(AND(A2="A",B2="semi(joe)"),500+((C2-12.5)*50),INDEX(DATA!$C$2:$C$13,MATCH(INPUT!A2&INPUT!B2,INDEX(DATA!$A$2:$A$13&DATA!$B$2:$B$13,0),0)))

[ROD_WARRIOR]

FDibbins,

You are a Genius.
It working

Thanks for your help

Now let me try to understand the formula, so I can reapply it