Office Question

[_-playero-_]

Hi all,

 

I'm making an inventory of some items, with a "Code", "Product name", "Price", and "Price minus the 30%", columns.

 

I'm wondering if is possible to automatically calculate "Price - 30%". Set a forumla to get the 30% less of the value of the cell next to it.

 

[facugaich]

C2 = The price of the first item on the list

 

Then you write this in D2

 

 

=(C2-(30*C2/100))

 

 

Simple maths my friend, there might an easier way though, I don't know.

 

To copy the formula just select the cell, then click & drag the right-bottom corner down.

Edited December 14, 2006 by facugaich

[_-playero-_]

This is great. I knew the formula, what I didn't know is that excel automatically sets the cell numbers, so I thought I had to add the formula manually to all 300 cells I have...

 

thanks!!!!!