Problem with my calculations

[Dorothy26138473siql]

Hello, I am having some problems with the calculations for our GST on my form. The GST 50 column should take the GST from gst.1 divide by half first and then round down second. It only needs to round down if the number is not perfectly divisible by 2 though. so if I enter 16.06 which is an even number, as the GST it should round to 8.03 but its not, its rounding down to 8.02.  If I have say 5.27 that isn't easily divisible, the government pays the lower half, we pay the higher half, so I need that to round down to 2.62. 

I had to redo my calculations for the Receipt total, GST on receipt  km $ and Total meals columns to the sum method,  but it seems to have broken my calculation script and validation script when i did that. I have attached the file. 

Any assistance would be amazing!

[Dorothy26138473siql]

and yes if you can show me the changes that would be good, i need to learn this stuff so i can  stop bugging you all 🙂

[Nesa Nurani]

That calculation already include your part?

[Dorothy26138473siql]

ok strange, this is how its calculating on my end in the sheet you sent me 

[Nesa Nurani]

I put your scripts back in "ProgramCostsRow" fields, now it will only calculate "GSThalf" fields.

https://drive.google.com/file/d/1KFIXSFdIVMNYB7kSvhNWFH8F3zZ6muuj/view?usp=sharing 

But from what I can see, your calculations in "ProgramCostsRow" fields may not be correct.

[Dorothy26138473siql]

I'm sorry I guess I am not understanding, when i open this one the GST 50 column no longer has a calculating field?

[Dorothy26138473siql]

I think I have figured it out...

[Dorothy26138473siql]

Yes! It is calculating correctly, I have now changed all of that last section to read only, which is great now no one can type in there and break it! Thank you again so much for your help! 

So this is the only calculation needed in the GST 50 column? if(event.value == 0)event.value = ""; and you changed it to read only, was there anything I missed.?