Newbee to Excel needs direction on how to create a formula to incorporate into a business estimate sheet. I have a cost and sell columns and wish to have the sell columns reflect a certain mark-up depending on the cost dollar amount. IE: if cost is under 100.00, then mark-up cost 100%. If cost is over 100.00 but less than 300.00, then mark up cost 50%. If cost is over 301 but less than 500, then mark up cost to 30%.
Thanks for any help.
Thanks for any help.