Thread: MATH COMPUTAION
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lehigh46 lehigh46 is offline
external usenet poster
 
Posts: 43
Default 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.