If Function

L

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!
 
G

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)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Formula 2
averaging cells 9
averaging data in multiple columns 6
average if 5
Measuring Average Changes 5
14 Day Average 4
conditional formatting 4
Average formula multiple worksheets 1

Top