I am trying to create a price list in word with formulas similar to excel. I basically have a price list designed in word and have inserted some columns with the discount structure in the header column, but I can't seem to figure out how to do the equations.
I need to have 3 columns of pricing based off their regular price. If was doing it in excel the formulas would read
=column:row*0.98 for the first volume discount
=column:row*0.965 for the 2nd volume discount
=column:row*0.95 for the 3rd volume discount
can someone please assist me with this. It is time sensitive and urgent. Thank you.