in one column, we have retail list. I want to set a formula so that
if price <= 49.99 it equals the list
if price 50-100 it equals 10% off
if price is 100+ it equals 20% off.

i've researched a lot in excel, and can't figure out how to setup this
formula... please advise.

Thanks
Brad