zzzprojects/zzzcode.ai

Generated Excel formula

Opened this issue · 1 comments

CedrineN commented

Hi,
When i copy the generated excel formula and paste it into the excel window I get an error message saying "there is something wrong with this formula". What is this due to? Do I need to do anything else before I can actually use the formula?

for example: =IF(A6="57461016806",IF(F7,VLOOKUP(LEFT(D7,2),Info!A:B,2,FALSE),""),"")&IF(A6="55651111921",IF(F7,VLOOKUP(LEFT(D7,2),Info!D:E,2,FALSE),""),"")

https://zzzcode.ai/excel/formula-generator?id=e481bb85-b7d0-457b-a02e-ea29cacee64f

JonathanMagnan commented

Hello @CedrineN ,

The formula looks good, but anything can be wrong in this formula such as if the lookup range, by example, doesn't contain the expected data.

Keep in mind this is generated by AI, so you can never trust at 100% what has been generated.

While we provide the service through our website, we cannot debug what the AI has been generated wrong.

Best Regards,

Jon