MATH COMPUTAION
On Wed, 27 Jul 2011 14:51:19 -0400, lehigh46
wrote:
Hi All:
This sounds simple but it's driving me nuts.
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.
I need formulas for A2 & A3.
Can someone please help me.
thanks in advance.
Tom
I need to claify that if the project is longer than 48 months, then A2
@ A3 would both show 12.
|