James Elliott - WA Rural Computers wrote:
I am copying and pasting price lists from my main supplier into a calc
worksheet and then increasing their wholesale price by my retail margin,
prior to posting the list onto my own Web site.
Here is what I am actually doing (you may need to widen your e-mail
client screen to make sense of the data - ie get the lines right):
1. I copy the price list from the supplier Web page and then copy it
into M$ Notepad (to remove any formatting other than the tab delimiter)
and get something like this in Notepad:
EDSXP7300V Small Office Home Office - economy E7300 C2D PC +MS Vista
Home Premium (VHP) 790
EDSXP7300P Small Office Home Office - economy E7300 C2D PC +MS XP
Professional (XPP) 830
EDSXP7300VM1 Small Office Home Office - economy E7300 C2D PC +MS VHP
+19IN M/M WS LCD 950
EDSXP7300VM2 Small Office Home Office - economy E7300 C2D PC +MS VHP
+22IN WS LCD 990
EDSXP7300PM1 Small Office Home Office - economy E7300 C2D PC +MS XPP
+19IN M/M WS LCD 990
EDSXP7300PM2 Small Office Home Office - economy E7300 C2D PC +MS XPP
+22IN WS LCD 1030
2. I then copy Notepad into a new, blank spreadsheet and optimise the
column widths. The last couple of columns look like this:
column C Col D
E7300 C2D PC +MS Vista Home Premium 790
E7300 C2D PC +MS XP Professional 830
E7300 C2D PC +MS VHP +19IN M/M WS LCD 950
E7300 C2D PC +MS VHP +22IN WS LCD 990
E7300 C2D PC +MS XPP +19IN M/M WS LCD 990
E7300 C2D PC +MS XPP +22IN WS LCD 1030
3. I then us a formula to calculate the retail price where:
wholesale price in cell D1 = $790
mark-up is $200
Retail price is recorded in cell E1 = D1+200
4. One would expect the retail price to be 790 + 200 = 990 but
according to Calc it is $200 ????
5. if I use the formula E1=D1 I get 790.
if I then edit that formula so it reads E1=D1+200 I get 200 ?
If anyone can throw some light on this I would be very much obliged.
Kind regards, James
Format both columns D & E as currency and then enter the formula as =(D1+200)
-Note the parentheses.
This works as I have tried it.
Personally, I would use my mark up as a percentage of the base and round down to an even dollar
amount by formatting. This prevents you having to enter the markup manually for each item. The
final price may differ a bit from what you are using but it should even out over the entire list and
it saves you time.
An example of this is =INT((D2 + (0.25*D2))) where your markup is 25%. If you leave off the INT()
it leaves the fractional amount as .xx cents
--
Gene Y.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
