1

I have a calculated column that is using a conditional IF statement to do a calculation.I am using a variation of this in 3 different Calc columns. The problem i have is that my amount are rounding up and I end up with an extra penny which in accounting is a no no. How do I incorporate a round down into this formula.

=IF([DTF/DWI/Admin/Jud]="DTF",([Sale Price]-[Title Transfer]-Towing-[Other Expenses])*0.7, 
IF([DTF/DWI/Admin/Jud]="DWI",([Sale Price]-[Title Transfer]-Towing-[Other Expenses])*0.7,
IF([DTF/DWI/Admin/Jud]="Jud",([Sale Price]-[Title Transfer]-Towing-[Other Expenses])*0.7,
IF([DTF/DWI/Admin/Jud]="Admin","0"))
2

In SharePoint, you can use ROUNDDOWN(number,num_digits) function to rounds a number down, toward zero.

In your case, the final formula should be

=ROUNDDOWN(IF([DTF/DWI/Admin/Jud]="DTF",([Sale Price]-[Title Transfer]-Towing-[Other Expenses])*0.7, 
IF([DTF/DWI/Admin/Jud]="DWI",([Sale Price]-[Title Transfer]-Towing-[Other Expenses])*0.7,
IF([DTF/DWI/Admin/Jud]="Jud",([Sale Price]-[Title Transfer]-Towing-[Other Expenses])*0.7,
IF([DTF/DWI/Admin/Jud]="Admin","0")),0)

So if the result, for example, is 3.3, the result of the ROUNDDOWN(3.3,0) will be 3

  • I had to add 2 more ) at the end of the Formula before the ,0) otherwise I was getting a syntax error otherwise this is exactly what I needed Thanks – Gary Peters Oct 12 '18 at 16:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.