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.

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.

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




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

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.

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.

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.

If you want zero as a result if I6 is blank why not

=IF(I6="",0,I77-I6)


--
Regards,

Peo Sjoblom



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

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.