A arKwelder Mar 24, 2010 #1 need to mark up 16800 items by 15% column e is my net and need column f with new prices
E Eduardo Mar 24, 2010 #2 opps you will enter 0.15 instead of 15 Eduardo said: Hi, in column F enter =E2*1.15 copy formula down you can have a cell where you enter the markup % like A1, then have F calculate it using =E2*(1+A1) in A1 you will enter 15 Click to expand...
opps you will enter 0.15 instead of 15 Eduardo said: Hi, in column F enter =E2*1.15 copy formula down you can have a cell where you enter the markup % like A1, then have F calculate it using =E2*(1+A1) in A1 you will enter 15 Click to expand...