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
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