Count with percent

I've made an invoice with form fields.
On every row with items there's 6 columns.

1. Article no
2. Item's name
3. How many items?
4. Price per item
5. Discount (in percent)
6. Sum of the row

The 6th column multiplies no 3 and no 4 to a sum.
It should also decrease the sum with the discount in no 5, but I just can't make this to work!

I know that this should be simple, but as long as the sum is different from 100 the discount will not calculte the right amount.

Please help my poor knowledge!

Danielh,

If you are using a table, you can use cell references in
your equation. The equation below inserted as a
calculation field in in cell f2 wil calculate the first
row of information:

=((c2*d2)-(e2*(c2*d2)))


-----Original Message-----
I've made an invoice with form fields.
On every row with items there's 6 columns.

1. Article no
2. Item's name
3. How many items?
4. Price per item
5. Discount (in percent)
6. Sum of the row

The 6th column multiplies no 3 and no 4 to a sum.
It should also decrease the sum with the discount in no
5, but I just can't make this to work!

I know that this should be simple, but as long as the sum
is different from 100 the discount will not calculte the
right amount.

Please help my poor knowledge!
.

Thank you greg!

That's the formula I was looking for...

"Greg" skrev:

Danielh,

If you are using a table, you can use cell references in
your equation. The equation below inserted as a
calculation field in in cell f2 wil calculate the first
row of information:

=((c2*d2)-(e2*(c2*d2)))


-----Original Message-----
I've made an invoice with form fields.
On every row with items there's 6 columns.

1. Article no
2. Item's name
3. How many items?
4. Price per item
5. Discount (in percent)
6. Sum of the row

The 6th column multiplies no 3 and no 4 to a sum.
It should also decrease the sum with the discount in no
5, but I just can't make this to work!

I know that this should be simple, but as long as the sum
is different from 100 the discount will not calculte the
right amount.

Please help my poor knowledge!
.