If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
mark up
need to mark up 16800 items by 15% column e is my net and need column f
with new prices |
#2
|
|||
|
|||
mark up
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 "arKwelder" wrote: need to mark up 16800 items by 15% column e is my net and need column f with new prices |
#3
|
|||
|
|||
mark up
opps you will enter 0.15 instead of 15
"Eduardo" wrote: 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 "arKwelder" wrote: need to mark up 16800 items by 15% column e is my net and need column f with new prices |
#4
|
|||
|
|||
mark up
.... and you may want =E2*(1+A$1) instead of =E2*(1+A1), if you are going to
copy down. -- David Biddulph "Eduardo" wrote in message ... opps you will enter 0.15 instead of 15 "Eduardo" wrote: 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 "arKwelder" wrote: need to mark up 16800 items by 15% column e is my net and need column f with new prices |
Thread Tools | |
Display Modes | |
|
|