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
Bookmarks