Deborah 0 Posted September 30, 2006 I need to write a formula for this Multiply quantity (500) by price (.12) both are mixed references continue to build formula to multiply the results of first calculation by (1 minus the discount 5%) the discount is a mixed reference. I cant seem to get it correct Share this post Link to post