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:
[TABLE="width: 253"]
<tbody>[TR]
[TD]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[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.