Do I ROUND or TEXT my over 60 past due result?

[John.McLaughlin]

Hello,

Currently when calculating invoices over 60 days due, the result is:

2807.14861111111 OVER 60 How do I format to read 2807.15? My formula is =SUMIF($A$5:$A$200,"<"&TODAY()-60,F5:F200)&(" OVER 60") A - Date column, F - Amount due column I have tried using both round & text at the beginning of the formula, and the middle, but nothing seems to work? Thanks in advance! JM

<tbody>
</tbody>

 

[Peter_SSs]

=TEXT(SUMIF($A$5:$A$200,"<"&TODAY()-60,F5:F200),"0.00")&" OVER 60"
should work.

 

[oldbrewer]

add 0.005 to the total and then format to 2 decimal places so
=SUMIF($A$5:$A$200,"<"&TODAY()-60,F5:F200)+.005&(" OVER 60")

 

[John.McLaughlin]

Thanks Peter! My mistake was putting TEXT/ROUND after SUMIF. I didn't think of preceding it.

 

[Peter_SSs]

Thanks Peter! My mistake was putting TEXT/ROUND after SUMIF. I didn't think of preceding it.

You're welcome. Glad it worked for you.