#### brannsiu

##### Distinguished
I have zero knowledge with Google Sheet or Excel

It's template of business invoice. I'd like to add "Amount Paid" and "Amount Due"

i.e Amount Due=Total Amount - Amount Paid

But most of the template have missed this part.

How to do it by myself??

Solution
You write a formula like
Code:
=A5-A6
where "A5" is the cell containing "total amount", and "A6" is the cell containing "amount paid". You write this formula in the cell where you want to hold "amount due".

I think you have to start with something more "basic", like how a spreadsheet works. Jumping straight into templates is not for absolute beginners.

#### Alabalcho

##### Judicious
You write a formula like
Code:
=A5-A6
where "A5" is the cell containing "total amount", and "A6" is the cell containing "amount paid". You write this formula in the cell where you want to hold "amount due".

I think you have to start with something more "basic", like how a spreadsheet works. Jumping straight into templates is not for absolute beginners.

Replies
0
Views
2K
Replies
7
Views
3K
Replies
4
Views
4K
Replies
1
Views
2K
Replies
1
Views
3K