show markup % in columns F-K when you put the markup (Col L) for a price (Col E)

Hello Excel Forum Guru's,
I have a sheet that I want to show % markup by putting the data in column N, which would show the percent total in the markup columns F-K. The price is in column E. I had a macro that will add a line to the table and it would need to carry the formula on the new line. I have attached the file. I would really appreciate any help offered. Thanks you.

i did not download your file. however, if you want to show a markup %age, that's a simple formula in a cell, and then copying it into other cells with the autofill handle. do you know how to do that?

I am so sorry I didn't explain well enough. I have attached a new file. I would like my file to look like table 1. I show table 2 which is what I want to change. Table 2 has the formula's in F19-K23 & N19-S23.

1) I would like to not show the all the 0.00 from the formula in F19-K23 and only so the calculation numbers.
2) I would like to eliminate having to put the % in columns N19-S23 and make it 1 column. See Table 1 N5-N9

I sure hope this is a better explanation.

I am sorry I attached the wrong file on example1. Example2 is correct

Hi Excel experts,
I played around with the attached file and was able to elimate the 0.00 showing in the formula cells. I sill would much appreciate help on just having 1 markup column (see table 1 N5-N9). Right now I have to put the markup in Col N-S (see table 2 N18-S23)for my calculation formulas to show in columns F-K.

Dear JeteMc,
Thank you so much for the help. It worked perfectly.