Long formula in excel

[amvega]

How can I separate a formula in excel that has the IF(AND ...function on it? It should be repeated over and over until it finds the right value in the array provided in a table to bring me back a formula that includes sum, and multiplying percentages. below is the way it should look, just by taking one line of values into account.

=IF(AND(A3>C7,A3<D7),A3*F7+E7)*101.2%

The formula should continue to search for this until it finds the right value to give me the total of the formula.

Any help will be appreciated it.

Thanks!

 

[steve the fish]

Try to provide some sample data and the result you are looking for

 

[amvega]

I have the table below where I have a range of values in tons that will calculate the total due (payment) depending on the amount of tons purchased. This formula include percentages. What I need to know is using the IF(AND to use a singe formula for when the tons are purchased. in other words, that by putting the amount of tons purchased in column a, then column b will look in the table to see if it defaults in the right category to give me the right total due.

I started the formula like: =IF(AND(A3>C7,A3<d7),a3*f7+e7)*101.2% below:
<D7),A3*F7+E7)*101.2%. I need this formula to continue to search in the table below until it finds the right criteria to give me the total

Production PBC	Total Dues	AGREEGATE DUES CALCULATION
125,000	$ -	Tons From	Tons To	MIN. FEE	PERCENTAGE FEE FROM TONS	CORE CPI	Amount due calculation description
1,873,220	$ 10,490.49	1	59,999	1,000	-	1.0120	$1,000 min. x Core CPI (1.2%) = 101.2%
1,073,459		60,000	149,999	1,000	0.011	1.0120	$1000 + (Total tons x .011) x Core CPI of 1.2%
482,501		150,000	499,999	1,000	0.009	1.0120	$1000 + (Total tons x .009) x Core CPI of 1.2%
59,999		500,000	999,999	1,000	0.007	1.0120	$1000 + (Total tons x .007) x Core CPI of 1.2%
13,992		1,000,000	1,999,999	1,000	0.005	1.0120	$1000 + (Total tons x .005) x Core CPI of 1.2%
27,333		2,000,000	4,999,999	1,000	0.0035	1.0120	$1000 + (Total tons x .0035) x Core CPI of 1.2%
1,768,106		5,000,000	9,999,999	1,000	0.0025	1.0120	$1000 + (Total tons x .0025) x Core CPI of 1.2%
885,095		10,000,000	9,999,999,999	1,000	0.0012	1.0120	$1000 + (Total tons x .0012) x Core CPI of 1.2%

<tbody>
</tbody>

</d7),a3*f7+e7)*101.2%>