Formula causing name error, where is the error?

Ok I finally got this to work as I want to report the values needed, but I get a name error

If C21,C22,C23 has a number value AA14 should read Tri sodium phosphate, AA15 Disodium phosphate, AA16 mono sodium phosphate, and AA17 phosphate. This works fine no issues

If C21,C22 has a number AA14 should read Di sodium phosphate, AA15 should read Mono sodium phosphate, and AA16 should read phosphate, and AA17 should be blank, However I am getting a name error there

If C21 has a number, AA14 should read Mono sodium phosphate, and AA15 should read Phosphate, and AA16, AA17 should be blank, but I am getting a name error there


Now when C21 has no number value AA14 should read Phosphate, and AA15,AA16,AA16 should be blank which they are and is working correctly.

So what is causing the #NAME? errors when the C21 and C22 have a number value??


Please help

I have been struggling with this for close to a day

AA17 shows Phosphate here, not an error.

AA16 shows Mono Sodium Phosphate.

I can't troubleshoot a workbook that isn't showing any errors such as you suggest.

Excel 2016 (Windows) 32 bit

	AA	AB	AC	AD
14	Tri Sodium Phosphate
15	Di Sodium Phosphate
16	Mono Sodium Phosphate
17	Phosphate
18

Sheet: Acetic Acid

Please update your forum profile if you are no longer using Excel 2007.

Your problem is using different double quotes =IF(AND(C21="";C22="");"";IF(AND(C22="";C23="");””;IF(AND(C23="";C24="");AF14;IF(C23<>"";AG14;""))))

Try =IF(AND(C21="";C22="");"";IF(AND(C22="";C23="");"";IF(AND(C23="";C24="");AF14;IF(C23<>"";AG14;""))))

Nice spot, Pepe!

@Ali
If you delete C22 and C23 the error triggers

I do wish members would provide workbooks showing the error - we shouldn't be having to jump through hoops to find it!

I already get the creeps when I see merged cells
This being said you are , as usual, right !

Pepe, That did it Thank YOU

I could not find the problem and it drove me NUTS!!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Originally Posted by born2dive00

Pepe, That did it Thank YOU

I could not find the problem and it drove me NUTS!!!

I just used the "evaluate formula" tool when the formula went berserk. It's not perfect but it does help