multiple calculations

N

Nick

Alrite,

I am not that experiened in Excel and was wondering if
anyone could help me with this prob I have:

I have a column of prices and I want to divide each number
within the column by 17.5%. Is there any way that I can do
this quickly instead of creating another column or
inputting every row manually???

Thanks

Nick
 
J

jeff

Hi,

A cell formula can't calculate on itself, so you'll have
to use (even temporarily) another column - say data is
in col A; in B1 enter =A1/.175 ; now copy down.
when finished, you can copy/cut the entire new column and
paste over the old.

jeff
 
F

Frank Kabel

Hi
insert this value in an empty cell, copy this cell and select your
target column. Goto 'Edit - Paste Special' and choose 'Divide'
 
S

Sandy Mann

Any time that I see 17.5% I always think that people are talking about UK
VAT. If it is not VAT then ignore this post.

To find the pre-VAT price put 1.175 in a cell, copy it, highlight the column
of gross costs and then Paste Special > Divide

HTH

Sandy
 
D

Dave Peterson

A slight variation.

Put 17.5 in a cell (say A1)
then put =$a$1 in another cell (say A2)

Then copy A2
select your range and do paste special|divide (like the others suggested)

but now look at the results of your paste special.

It'll look like:
=98/($A$1)

Now whenever your VAT changes, you just change $a$1 and all the formulas adjust.
 
Top