LinkBack URL
About LinkBacks
rexy69 
Hi
See below and check if this helps , may be an alternative to lookup
=IF(AND(A1>=1, A1<=3.9),0,
IF(AND(A1>=4, A1<=9.9),1,
IF(AND(A1>=10,A1<=19.99),2,3))
Hi
See below and check if this helps , may be an alternative to lookup
=IF(AND(A1>=1, A1<=3.9),0,
IF(AND(A1>=4, A1<=9.9),1,
IF(AND(A1>=10,A1<=19.99),2,3))
Never confuse a single defeat to the final defeat.
Careful with the if statement option. Entering a value of "9.99" or a "3.95" for example will result in a "3". It should be more along the lines of:
=IF(AND(A1>=1,A1<4),0,IF(AND(A1>=4,A1<10),1,IF(AND(A1>=10,A1<20),2,3))
Last edited by clabulis; 09-06-2014 at 01:00 PM.
thanks for all the responses, just tried Clabulis' method and it worked perfectly
Many Thanks!!!!!1
REP+
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks