I would like one of four discount percentages to appear on a spreadsheet,
depending on what the dollar amount is in A1...
If A1 is equal to or greater than $600 and less than or equal to $1,500 the
discount is 5%
If A1 is equal to or greater than $1,501 and less than or equal to $3,000
the discount is 10%
If A1 is equal to or greater than $3,001 and less than or equal to $6,000
the discount is 15%
If A1 is equal to or greater than $6,001 and less than or equal to $15,000
the discount is 20%
Thank you.