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