I need a "multiplyIF" formula...

[halliserin]

I work for a translation/interpretation company and I am trying to create a spreadsheet in which I can have the different services we provide multiplied by the rate we charge for that service. One column with the service (On-site, translation, ASL, etc.), another with the length of time. Each of these services has a different hourly rate so I need a way to tell Excel to determine which service it is and multiply the rate by the length of time which is indicated in another column, entering the total cost of the service in another cell.

Is this at all possible???

Many, many thanks!! I've been searching for weeks!!

Erin

 

[lrobbo314]

For simplicity sake I created a sheet with some sample data. Column A has Services, Column B has Time Spent. Column C will have the formulas. We need to make a table of Services and Rates to look up. I have this in the range of G1:H1.

So if our date looks like what's below, then the formula you would paste in the first Total cell would be, =VLOOKUP(A2,$G$1:$H$2,2,FALSE)*B2. Then just copy it down.
[TABLE="width: 204"]
<TBODY>[TR]
[TD]Service</SPAN>[/TD]
[TD] Time</SPAN>[/TD]
[TD] Total</SPAN>[/TD]
[/TR]
[TR]
[TD]ASL</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[/TR]
[TR]
[TD]Translation</SPAN>[/TD]
[TD="align: right"]4</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL span=2></COLGROUP>[/TABLE]