CULUMN REFERENCE TO CELL IN FORMULA

  • Thread starter Thread starter Werx
  • Start date Start date
W

Werx

Hello all,

I am working on a Fomula for a price list that needs to contain a refrence
to a Column to calculate a % addition (tax). There is also a column which
has a % discount which takes precidence to the tax.

ie A2 = $15, B2 = A2-20%, C2 = (A2 or B2) *1.1

When printing a list that contains a 20% discount for the customer, I hide
column A. Leaving B as the price they see. On top of this I need to add %GST
which I use in Column C

ie C2 = A2*1.1
1.1 is the Tax%

I need the A2 part to change when displaying a discounted price
(see example1 C2).

In C1 I place the the Column Ref. The Row must change with the corresponding
row.
ie. C15 = A15*1.1

Any help would be greatly appreciated

TKS
 
Werx

If you put an A or B in C1 then put
=INDIRECT($C$1&ROW())*1.1 in C2 and copy down.


Tony
 
Back
Top