# Auto calculate totals and sums based on variable numbers

1. ## Auto calculate totals and sums based on variable numbers

Hi,
I'm trying to auto calculate something based on this:

Amount Inside No Fees
14.00 or less 1 (= amount minus inside fee minus 3)
14.01 to 20.00 2 (= amount minus inside fee minus 3)
20.01 to 24.00 2.5 (= amount minus inside fee minus 3)
24.01 to 50.00 2.9 (= amount minus inside fee minus 3)
50.01 and above 3.4 (= amount minus inside fee minus 3)

So that if i put a number in the left column between one of those value it autocalculates the other values? Is that easy?

Cheers,

Benn  Register To Reply

2. ## Re: Auto calculate totals and sums based on variable numbers

1st, change what you have in column C, to what I have shown in column B...
 B C D E 3 Amount Inside No Fees 4 0 14.00 or less 1 (= amount minus inside fee minus 3) 5 14.01 14.01 to 20.00 2 (= amount minus inside fee minus 3) 6 20.01 20.01 to 24.00 2.5 (= amount minus inside fee minus 3) 7 24.01 24.01 to 50.00 2.9 (= amount minus inside fee minus 3) 8 50.01 50.01 and above 3.4 (= amount minus inside fee minus 3)

Then use this in H11, copied down...
=IF(G11="","",VLOOKUP(G11,\$B\$4:\$D\$8,3,1))
The "No Fee" calc would be...
=G11-H11-3  Register To Reply

3. ## Re: Auto calculate totals and sums based on variable numbers

you can use lookup  Register To Reply

4. ## Re: Auto calculate totals and sums based on variable numbers

Hey guys, that's awesome. Thank you soooo much  Register To Reply

5. ## Re: Auto calculate totals and sums based on variable numbers

Happy to help   Register To Reply