James Elliott - WA Rural Computers skrev:
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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.14/1918 - Release Date: 2009-01-27 07:26
One thing that will give this result is if D1 is formattet as text.
Erling Larsen
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org