On Wed, 27 Jul 2011 13:29:04 -0700, "joeu2004"
wrote:

"lehigh46" wrote:
in message ...
A1 contains the number of months for a construction project. (manual
input)
A2 looks @ A1 and calculates the number of months greater than 24 but
less than 36.
A3 looks at A1 and calculates the number of months greater than 36 but
less than 48.
A4 calculates the number of months greater than 48.

A2: =MAX(0,MIN(12,A1-24))
A3: =MAX(0,MIN(12,A1-36))
A4: =MAX(0,A1-48)



Thanks joeu2004

This doesn't work for me, so I'll give you a few examples of what I
need to see.


Ist example is that A1 = 28
Then A2 would = 4
A3 would = 0
A4 would = 0


2nd example is that A1 = 39
Then A2 would = 12
A3 would = 3
A4 would = 0


3rd example is that A1 = 52
Then A2 would = 12
A3 would = 12
A4 would = 4

To sum it up, A1 = "total monthes" This number is keyed in by hand.
A2 shows the number of months over 24 BUT not more than 12. (between
24 & 36) See 1st example.
A3 shows the number of months over 36 BUT not more than 12. (between
36 & 48) See 2nd example.
A4 shows the number of ALL months over 48.