=IF(price<=49.99,price,IF(price100,price*0.8,pric e*0.9))
or
=IF(price<=49.99,price,IF(AND(price49.99,price<10 0),price*0.9,price*0.8))
--
Tim Zych
www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
A free, powerful, flexible Excel utility
"byrddog75" wrote in message
...
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