|
| 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
March 24th, 2010, 06:01 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
mark up
need to mark up 16800 items by 15% column e is my net and need column f
with new prices 
|
|
#2
March 24th, 2010, 06:14 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
March 24th, 2010, 06:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
March 24th, 2010, 08:51 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
