Percentages in Excel

[iambenmunro]

Hi all,

Sorry if this has been asked before but I'm looking to do a list of invoice amounts in Excel minus 20%. This is just to give me a glance as I was advised to save 20% of each invoice to cover tax etc. when my accountant does my self-assessment/return.

My idea is like this:

Invoice No | Amount | 20% of Invoice
INV 1. ?200 ?40

Sorry I couldn't use the tables feature on here as I wasn't sure what to put in the code.

If someone could help me, that would be fab. I've tried doing it with a formula but it didn't work.

Thanks in advance!
Ben

[HansDouwe]

Try
Cell B2: Invoice Amount-Value
Cell B3: =20%*B2 (20% if the Invoice Amount Value)
Cell B4: =B2-B3 (Invoice Amount Vanlue minus 20%]

[iambenmunro]

Thank you. I tried that and still didn't work. This is what I have so far but I've been manually adding the 20% amount rather than Excel doing this.

Attachment 791027

Thanks in advance.
Ben

[FDibbins]

Pics often dont come though, rather upload a sample WB