Help With Formula

[Paynter3420]

Hello!

I have a program (well, excel program) for my work.

The simple formula for this is

Job amount x rate (rate is found by a formula in another tab with the state and monthly rate). For example, Arkansas at 12 months is .08699.

On the first page I have
Job amount (enter manually)
Months (choose from a list, already completed)
State (choose from a list, already completed)
Rate (I need some type of formula that picks the rate from the months and state from the other tab)

This gives me the monthly payment and I can do the rest from there.

If it helps, on the page with the states and rates I can format it whatever way will be easiest.

Thanks for your help, if it would be easier, I can email this file to you.

Thanks!!

 

[wideboydixon]

Your description doesn't make it 100% clear but this might get you going in the right direction:

Book1
	A	B	C	D	E	F
1	Job Amount	1234		State	Month	Rate
2	Month	March		Arkansas	January	0.07652
3	State	Arkansas		Arkansas	February	0.09264
4	Rate	0.08699		Arkansas	March	0.08699
5	Formula	107.3457		Oregon	January	0.071528
6				New York	February	0.002073
7				Texas	March	0.816595
Sheet1

Cell Formulas
Range	Formula
B4	=SUMPRODUCT(($D$2:$D$7=B3)*($E$2:$E$7=B2)*($F$2:$F$7))
B5	=B1*B4

WBD