Hi,
Please help me to use the rounding off formula in the existing formula as below:
- If ([taxable amount] *(5/100)) = [VAT amount] then "No issues" else "Please explain the difference in the tax amount" endif
- If [taxable amount] / [VAT amount] = 5.00 Or If [taxable amount] / [tax amount] = "5.00%" then "No Issues" else "Please explain whether this is PMS sale. If no then please explain the nature of transaction" endif
In the first formula I want the result of the multiplication to be rounded off upto 2 decimals and in the second formula i want the result of the division to be rounded off upto 2 decimals.
Also you can correct me in case if i have formulated it wrongly in the above formula according to the data provided. I just want to cross check the Tax amount amount and the rate of rate. It should be "5.00%"
Also attaching the data for your reference.
Thank you in advance.
Regards,
Neha
