On Tue, 28 Jun 2005 12:30:43 -0500, Hansel
wrote:

This equation is almost done, I just need to add an extra instruction
that will NOT round an averaged number that contains a .25 or .75. I am
calculating averages of oil prices so they have to be as exact as
possible. Thank you in advance for your help! :)

I assume you mean "ends with" rather than "contains".

But what if the averaged number ends with .44?

Do you, perhaps, want to do your rounding to the nearest 0.25?

If so:

=IF(COUNT(H101:H102)=0,H101,
IF(AND(COUNT(H101:H102)=2,H101<H102),
ROUND(AVERAGE(H101:H102)*4,0)/4,AVERAGE(H101:H102)))


--ron