hamburg18w
Technical User
I am running MS Excel 2003 (Windows) and need help with building a formula. I am a cell (H31) that in itself has a addition formula and need to build the following formula:
if h31 is less than 14 return 1
if h31 is greater than 13 and less that 17 return 2
if h31 is greater than 16 and less that 20 return 3
if h31 is greater than 19 and less that 22 return 4
if h31 is greater than 21 and less that 28 return 5
if h31 is greater than 28 return 6
Could you please help me build this formula? Thank you!
Juan
if h31 is less than 14 return 1
if h31 is greater than 13 and less that 17 return 2
if h31 is greater than 16 and less that 20 return 3
if h31 is greater than 19 and less that 22 return 4
if h31 is greater than 21 and less that 28 return 5
if h31 is greater than 28 return 6
Could you please help me build this formula? Thank you!
Juan