To automatic to link up

[eman7209]

Viamerica.xlsx

Hello what I'm trying to do is a link for example i type up an amount on the AMOUNT and where is the FEE the amount pops up on the cell
If you see on the Commission side i want the fee to pop up on that amount of the commission if you type up say $1500 the fee of $100 pops up on the cell where it says Fee's i hope you could help me out on it

oh i have office 2013
thanks

[quekbc]

I created a new table, similar to the one you have so I can use a LOOKUP function to do the trick. (also see attached)

in cell AK4

Please Login or Register  to view this content.

Commission
From	To	Commission Rate
$0	$1	$0.00
$1	$1,999	$10.00
$1,999	$2,999	$20.00
$2,999	$3,999	$30.00
$3,999	$4,999	$40.00
$4,999	$5,999	$50.00