Use MAX instead

=I77-IF(I6="",MAX(I6:I36),I6)


--
Regards,

Peo Sjoblom



"Lyn new at access" wrote in
message ...
I think this will work:

=I77-(IF(I$6="",(LARGE(I$6:I$36,1)),I$6))

Lyn

"Lyn new at access" wrote:

I have a calculation: I77-I6 How do I use the Large Function if I6
is
blank?
This only happens if the first day of the month falls on a weekend. I am
getting the #Num error.