Ask Your Question
0

how to calculate GST in calc

asked 2017-10-05 10:20:07 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

hello all this is my first post so recently ive been tasked to create a invoice template for a new company and ive downloaded this templatefrom libreoffice.org and im trying to replace the Discount % section with GST so we can automatically add the GST to the customers bill. my question is what should i put in place of sections f33 and f34 to add a percent from the line total? thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-10-05 12:22:49 +0200

robleyd gravatar image

In F33 put the GST percentage rate, e.g. for Australia 10 (percent). Simply change F35 to

=IF(F32+F34=0;"0.00";F32+F34)

So you add the amount as GST rather than subtracting a discount.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-10-05 10:20:07 +0200

Seen: 112 times

Last updated: Oct 05 '17