Thread: MATH COMPUTAION
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lehigh46 lehigh46 is offline
external usenet poster
 
Posts: 43
Default MATH COMPUTAION

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