What about this calculation:

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

Would it work?

Lyn


"Lyn new at access" wrote:

Peo,

I have an excel spreadsheet that does calculations. I have a calculation

=I77 - I$6

The cell I77 has a value of 32.45%

The cell I6 has is blank.

When the calculation is performed my result is 32.45%.

i.e. blank minus 32.45% = 32.45%.

I want it to use 32.45% - 32.45% = 0%.

This is wrong. My result should take 32.45% - 32.45% and get a result of 0%.

What I want is if I6 is blank, to look for the largest value and use that
value to subtract from.

If calculation is done everyday of the month. It seems to work if the 1st
of the month is on a weekday. If the 1st of the month is on the weekend, I
do not run the calculation so it starts out being blank.

I hope this clears it up a little.

Lynne







I have no idea what you mean, what has LARGE to do with I77-I6, or with
the
first day of a month falling on a weekend?


--
Regards,

Peo Sjoblom



"Lyn new at access" wrote in
message ...
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.