IF(ISNUMBER(SEARCH forumla starts giving FALSE value after the 10th formula?!

Hey there,

so I wrote this formula out and it's worked up to the 10th formula after which it has just started giving FALSE as the value even though I can see values in column D that should mean a TRUE value is given, can anyone spot/explain why this is happening?

=IF(ISNUMBER(SEARCH("43591",D:D)),"1st Delivery", IF(ISNUMBER(SEARCH("43592",D:D)),"2nd Delivery", IF(ISNUMBER(SEARCH("43593",D:D)),"3rd Delivery", IF(ISNUMBER(SEARCH("43594",D:D)),"4th Delivery", IF(ISNUMBER(SEARCH("43595",D:D)),"5th Delivery", IF(ISNUMBER(SEARCH("43596",D:D)),"6th Delivery", IF(ISNUMBER(SEARCH("43597",D:D)),"7th Delivery", IF(ISNUMBER(SEARCH("43598",D:D)),"8th Delivery", IF(ISNUMBER(SEARCH("43599",D:D)),"9th Delivery", IF(ISNUMBER(SEARCH("43600",D:D)),"10th Delivery", IF(ISNUMBER(SEARCH("43611",D:D)),"11th Delivery", IF(ISNUMBER(SEARCH("43612",D:D)),"12th Delivery", IF(ISNUMBER(SEARCH("43613",D:D)),"13th Delivery", IF(ISNUMBER(SEARCH("43614",D:D)),"14th Delivery", IF(ISNUMBER(SEARCH("43615",D:D)),"15th Delivery",
IF(ISNUMBER(SEARCH("43616",D:D)),"16th Delivery",))))))))))))))))

Thanks in advance!

It would help if you attached a sample Excel workbook, as I'm sure you don't need 16 levels of nested IFs to achieve that.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

Oh brill, I've attached now thank you!

Any reason why this part your formula
IF(ISNUMBER(SEARCH("43600",D:D)),"10th Delivery", IF(ISNUMBER(SEARCH("43611",D:D))
Jumps from 43600 to 43611, the rest seems to be sequential numbers

You're a star, new it was something I had gone blind to. Gosh, thank you a bunch!

Glad to help & thanks for the feedback

If you could forego the ordinal numbers, then you could replace your long formula with this in F2:

=IF(AND(INT(D2)>=43591,INT(D2)<=43606),INT(D2)-43590&" delivery","")

then copy down.

Hope this helps.

Pete