Dear all, i need excel formula for resolving my below issue


If cell A1 having value in between (3000 to 3499) then add 15% with A1 , keep the results in the cell B1

Or

If cell A1 having value in between (4000 up) then add 20% with A1 ,keep the results in the cell B1.