Count with percent

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

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
Click to expand...
5, but I just can't make this to work!
I know that this should be simple, but as long as the sum
Click to expand...
is different from 100 the discount will not calculte the
right amount.
 
Back
Top