=IF(AND(A1=600,A1<=1500),5%,IF(AND(A1=1501,A1<=3 000),10%,IF(AND(A1=3001,A1<=6000),15%,IF(AND(A1= 6001,A1<=15000),20%))))
is the answer to your question, but this MAY produce a result of FALSE
because A1 may be <600 or A1 may be 15000 and you didn't account for these
cases.
HTH

"joaniemic" wrote:

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.