• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula for Creating Range

T

Tarun.M

New Member
Please help me with the formulla for creating a range.

Example: I want to create a range if the # are between 1-5 as "01-05" and if the # are between 6-10 as "06-10" and so on till 100 & also want to add a condition if the #'s are greater than 20000 then it shows "Not Ordered" I have a formulla as follows:


=IF(O99<6,"00-05 Days",IF(O99<11,"06-10 Days",IF(O99<16,"11-15 Days",IF(O99<21,"16-20 Days",IF(O99<26,"21-25 Days",IF(O99<31,"26-30 Days",IF(O99>30<100,"30 Days +",IF(O99>20000,"Not Ordered")))))))).


My problem is the # which is above 32 shows as False Error. Please help.
 
Hi Tarun.M


Welcome to the Forumm..


If condition never support IF(O99>30<100) in a single line..

try to use the below..


=IF(O99<6,"00-05 Days",IF(O99<11,"06-10 Days",IF(O99<16,"11-15 Days",IF(O99<21,"16-20 Days",IF(O99<26,"21-25 Days",IF(O99<31,"26-30 Days",IF(AND(O99>30,O99<100),"30 Days +",IF(O99>20000,"Not Ordered")))))))).


and whats about 101 to 20000 .. :)


Regards,

Deb
 
You must log in or register to reply here.
Back
Top