I am trying to create a formula for the following:
If cell D5<$100 then multiply by 25% in cell G5
If cell D5=$100 and <$999 then multiply by 20% in cell G5
If cell D5$999 then multiply by 15% in cell G5