|I'm trying to work out a formula where it can do the following|
if cell if less then 249.99= 1% of the cell amount
If cell is is between 250 to 999.99 = 1.5% of the cell amount
if cell is more then 1000.00 = 2% of cell amount,
The cell I'm using is E2 for this example.
Any help would be greatly received.