If Function

[Liz]

I was wondering if there is a way to perform the following analysis on a
series of different numbers.

For example, you have the following:

column a b c d
374 347 290 337 (average)
You want to perform the following functions on the average number,
If there three month average + 50 was <300 - minimum quota is 300 new lines

If the three month average was HIGHER than 2 of the 3 months, the actual
average was used

If the three month average was LOWER than 2 of the three months -

If the average number was < 1000, I added 50 to the average, and that is
their quota
If the average number was >1000, I added 150 to the average, and that is
their quota

Any thoughts would be greatly appreciated!

 

[GSnyder]

A fun challenge! Try this out:

Assuming your months are in A1,B1,C1 and the average is in D1, then place
this formula in E1:
=IF(D2<300,300,IF(COUNTIF(A2:C2,"<"&D2>1),D2,IF(D2>1000,D2+150,D2+50)))