Calculate a zero instead of the actual results?

[Ltat42a]

Hello All, I use a formula to calculate the number of days between 2 dates. I use these results to get an average, but I don't want to average anything with 3 days or less. Kind of like a library book, it gets checked out on 1 date, then comes back in on another date. If the result equals 3 days (or less), how can I alter my formula [=IF(E36="","",(E36-A36))] to display a 0 (zero)? Here is the average formula I'm using - =AVERAGEIF(F36:F120,"<>0"), just looking to find an average with a result of 4 or more.
Thanks,

[canapone]

Hi,

not sure (my bad)

=IF(E36="","",(A36-E36)*((A36-E36)>3))

Regards

[Ace_XL]

You could continue using your existing formula to display correct number of days

Just change the AVERAGEIF formula to

=AVERAGEIF(F36:F120,">3")

[Ltat42a]

Very nice!, both formulas are working good! Thank you both!

[canapone]

Hi,

thanks for providing kind feedback.