Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Price Question about EXCEL


Guest

Recommended Posts

Posted

I think that I change price of vender list by going to format cells... I need to increase prices by a %... LOL... WHAT option is it... or do I have to change every 15,000 items one by one...

Posted

Do you mean change them in MS Excel? If so, type the percentage increase you desire in a blank cell (if 20% increase, type 1.20) Copy this cell. Select all of the cells you wish to change. Right click and select paste special, multiply.

 

Sorry if you meant something else.

Posted

So then if I need lets say a 175% mark up then I would type 1.175 then click multiply... I do that and I get back the same coulam that the numbers are not right... SO that prob would tell me that I am not doing it right... LOL...

Posted

Put 1.75 in a blank cell.

 

<right-click> on it and choose "Copy"

 

Highlight the column you want to multiply.

 

Click "Edit" then "Paste Special"

 

In the dialogue box that pops up, in the top portion be sure "All" is selected.

 

In the bottom portion select "Multiply".

 

Then click "OK"

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Posted

Hooked On Fonix Worked for me... LOL... Let me go give it a try... THX BOSS...

Posted

OK>>> SWEET>>> GOT IT... 175% would be 2.75

That gives me the right number... THX EVER SO MUCH EVERY ONE....

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...