Multiple Requirements for answer
I am having trouble finding a formula that will work, I am trying work the following out
if cell = greater then 3 answer is 1, but if cell is greater then 7 answer is 2, but if cell is greater then 11 answer is 3, but if cell is greater the 15 answer is 4.
any suggestions would be greqatly appreciated.
IF(AND(A4>3,A4<=7),1,IF(AND(A4>7,A4<=11),2,IF(AND(A4>11,A4<=15),3,IF(A4>15,4,"NA"))))
A4 is the cell where you enter the value.
Hi
List your limits in col D1 to D5 (3,7,11,15,100) and result in col E 1 to E4(0,1,2,3,4)
B4=vloookup(A4,$D$1:$E$5,2,true) drag the formula till the end of data
RAvi
Last edited by ravishankar; 04-28-2008 at 08:27 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks