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!

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,"<"&D21),D2,IF(D2 1000,D2+150,D2+50)))