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!