IF function for PLUS has more than 64 levels of nesting

Originally Posted by benishiryo

welcome to the forum, Rizarusty. do upload an excel sample so that we do not have to manually key in your data to do a testing. input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.*

the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

it looks like all those names will result in F7+30. i didnt check every single one though. and the last part is if they are not those names, then +14? 2 ways:

list all the possible NAMA OUTLET in column J for eg. the number to add in column K. so:
=F7+IFERROR(VLOOKUP(C7,J:K,2,0),14)
this will add up the days based on the name in column J and the number in column K. if it can't find the name, then it will plus 14.

another way:
list the possible names in column J too. but you don't have to input the numbers in column K if all of them are 30. then:
=F7+IF(COUNTIF(J:J,C7),30,14)
that is to add 30 if the name can be found. otherwise, add 14.

sorry my bad, i'm new here :D

thnx's i'll try it, and hope its works

TY all for u'r help.

yes i want to make a list what my costumer deadline where i'm separate it in 2 categories 30 and 14, and i can control it which one is 30 days, and which one is 14 day. and my costumer is more than 64.
Hope U guys know what i mean, my bad english.

Originally Posted by benishiryo

welcome to the forum, Rizarusty. do upload an excel sample so that we do not have to manually key in your data to do a testing. input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.*

the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

it looks like all those names will result in F7+30. i didnt check every single one though. and the last part is if they are not those names, then +14? 2 ways:

list all the possible NAMA OUTLET in column J for eg. the number to add in column K. so:
=F7+IFERROR(VLOOKUP(C7,J:K,2,0),14)
this will add up the days based on the name in column J and the number in column K. if it can't find the name, then it will plus 14.

another way:
list the possible names in column J too. but you don't have to input the numbers in column K if all of them are 30. then:
=F7+IF(COUNTIF(J:J,C7),30,14)
that is to add 30 if the name can be found. otherwise, add 14.

TY, it works, i use this one:

=F7+IFERROR(VLOOKUP(C7,XFC:XFD,2,0),14)