Excel Formula - Too Many Arguments Error

[Zedrick13]

Hi, everyone. When I try to use the formula below, I always get the error in Excel saying " You've entered too many arguments for this function." What do you think is wrong with the formula below and how can I correct it?

=IFERROR(IF([@JIRA1]<>"",[@JIRA1],IF(ISBLANK([@JIRA1]),[@JIRA2],IF(ISBLANK([@JIRA2]),[@JIRA3],IF(ISBLANK([@JIRA3]),[@JIRA4],IF(ISBLANK([@JIRA4]),[@JIRA5],IF(ISBLANK([@JIRA5]),[@JIRA6],IF(ISBLANK([@JIRA6]),[@JIRA7],IF(ISBLANK([@JIRA7]),[@JIRA8],IF(ISBLANK([@JIRA8]),[@JIRA9],IF(ISBLANK([@JIRA9]),[@JIRA10],IF(ISBLANK([@JIRA10]),[@JIRA11],IF(ISBLANK([@JIRA11]),[@JIRA12],IF(ISBLANK([@JIRA12]),[@JIRA13],IF(ISBLANK([@JIRA13],[@JIRA14])))))))))))))),"")

Thanks in advance!

 

[sandy666]

try

=IFERROR(IF([@JIRA1]<>"",[@JIRA1],IF(ISBLANK([@JIRA1]),[@JIRA2],IF(ISBLANK([@JIRA2]),[@JIRA3],IF(ISBLANK([@JIRA3]),[@JIRA4],IF(ISBLANK([@JIRA4]),[@JIRA5],IF(ISBLANK([@JIRA5]),[@JIRA6],IF(ISBLANK([@JIRA6]),[@JIRA7],IF(ISBLANK([@JIRA7]),[@JIRA8],IF(ISBLANK([@JIRA8]),[@JIRA9],IF(ISBLANK([@JIRA9]),[@JIRA10],IF(ISBLANK([@JIRA10]),[@JIRA11],IF(ISBLANK([@JIRA11]),[@JIRA12],IF(ISBLANK([@JIRA12]),[@JIRA13],IF(ISBLANK([@JIRA13],[@JIRA14]))))))))))))))),"")

 

[Zedrick13]

Still got the same error. Thanks for trying to help.

try

=IFERROR(IF([@JIRA1]<>"",[@JIRA1],IF(ISBLANK([@JIRA1]),[@JIRA2],IF(ISBLANK([@JIRA2]),[@JIRA3],IF(ISBLANK([@JIRA3]),[@JIRA4],IF(ISBLANK([@JIRA4]),[@JIRA5],IF(ISBLANK([@JIRA5]),[@JIRA6],IF(ISBLANK([@JIRA6]),[@JIRA7],IF(ISBLANK([@JIRA7]),[@JIRA8],IF(ISBLANK([@JIRA8]),[@JIRA9],IF(ISBLANK([@JIRA9]),[@JIRA10],IF(ISBLANK([@JIRA10]),[@JIRA11],IF(ISBLANK([@JIRA11]),[@JIRA12],IF(ISBLANK([@JIRA12]),[@JIRA13],IF(ISBLANK([@JIRA13],[@JIRA14]))))))))))))))),"")

 

[sandy666]

hm,
it should work

[SIZE=1]
=IFERROR(
	IF([@JIRA1]<>"",[@JIRA1],
		IF(ISBLANK([@JIRA1]),[@JIRA2],
			IF(ISBLANK([@JIRA2]),[@JIRA3],
				IF(ISBLANK([@JIRA3]),[@JIRA4],
					IF(ISBLANK([@JIRA4]),[@JIRA5],
						IF(ISBLANK([@JIRA5]),[@JIRA6],
							IF(ISBLANK([@JIRA6]),[@JIRA7],
								IF(ISBLANK([@JIRA7]),[@JIRA8],
									IF(ISBLANK([@JIRA8]),[@JIRA9],
										IF(ISBLANK([@JIRA9]),[@JIRA10],
											IF(ISBLANK([@JIRA10]),[@JIRA11],
												IF(ISBLANK([@JIRA11]),[@JIRA12],
													IF(ISBLANK([@JIRA12]),[@JIRA13],
														IF(ISBLANK([@JIRA13],[@JIRA14])
															)
														)
													)
												)
											)
										)
									)
								)
							)
						)
					)
				)
			)
		)
			,"")[/SIZE]

 

[sandy666]

=iferror(
	if([@jira1]<>"",[@jira1],
		if(isblank([@jira1]),[@jira2],
			if(isblank([@jira2]),[@jira3],
				if(isblank([@jira3]),[@jira4],
					if(isblank([@jira4]),[@jira5],
						if(isblank([@jira5]),[@jira6],
							if(isblank([@jira6]),[@jira7],
								if(isblank([@jira7]),[@jira8],
									if(isblank([@jira8]),[@jira9],
										if(isblank([@jira9]),[@jira10],
											if(isblank([@jira10]),[@jira11],
												if(isblank([@jira11]),[@jira12],
													if(isblank([@jira12]),[@jira13],
														if(isblank([@jira13]),[@jira14]
															)
														)
													)
												)
											)
										)
									)
								)
							)
						)
					)
				)
			)
		)
			,"")

last if, isblank has two arguments - should be one

 

[Zedrick13]

You're right. Missed that ")." Thanks!

=iferror(
    if([@jira1]<>"",[@jira1],
        if(isblank([@jira1]),[@jira2],
            if(isblank([@jira2]),[@jira3],
                if(isblank([@jira3]),[@jira4],
                    if(isblank([@jira4]),[@jira5],
                        if(isblank([@jira5]),[@jira6],
                            if(isblank([@jira6]),[@jira7],
                                if(isblank([@jira7]),[@jira8],
                                    if(isblank([@jira8]),[@jira9],
                                        if(isblank([@jira9]),[@jira10],
                                            if(isblank([@jira10]),[@jira11],
                                                if(isblank([@jira11]),[@jira12],
                                                    if(isblank([@jira12]),[@jira13],
                                                        if(isblank([@jira13]),[@jira14]
                                                            )
                                                        )
                                                    )
                                                )
                                            )
                                        )
                                    )
                                )
                            )
                        )
                    )
                )
            )
        )
            ,"")

last if, isblank has two arguments - should be one

 

[sandy666]

You're welcome

 

[Zedrick13]

Uhm, I don't know what's wrong, but it seems that even if it is now correct, it doesn't work as I expected it to. So, I have rows G4-U4 and I applied the formula in G4. What I want the formula to do is copy the value of the nearest non-empty cell among cells H4 to U4. Do you think you can help me please?

You're welcome

 

[sandy666]

any link to example desensitized excel file with original structure of source data and expected result?

 

[Fluff]

Maybe
=INDEX(H4:U4,MATCH("*",H4:U4,0))