Large Function in a calculation

L

Lyn new at access

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

Peo Sjoblom

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?
 
C

CLR

Like Peo says, your formula and description don't seem to corelate......but
maybe something along these lines will help........

=IF(ISERR(A1),"NoDate",A1)
or
=IF(ISERR(YourFormula,"NoDate",YourFormula)

Vaya con Dios,
Chuck, CABGx3
 
L

Lyn new at access

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
 
L

Lyn new at access

What about this calculation:

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

Would it work?

Lyn
 
Top