I tipi di file classici non potranno più essere utilizzati a partire da gennaio 2021. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

Formula "#NAME?" error on export to .xlsx

Con risposta
0

Commenti

4 commenti

  • Scott Paasch
    I have had that same problem with other formulas and I found out it is a formatting issue, it would convert the cells into a text value rather than a number value. In the cell(s) that are having the error, may want to add in the formula =NUMBERVALUE( and in the export it will export it as a number (if that is what you are after) and this should elimintate the #NAME error on the export.  
    0
  • Jeremy Shumilak
    Thanks good idea, but my formula returns a text value so this would return an error, also Workiva doesn't seem to recognize the =NUMBERVALUE formula so creates an error in Workiva?
    0
  • Scott Paasch
    Try using the =TRIM( formula this removes all extra characters except spaces between words and kicks it out as text.
    I have used the NUMBERVALUE in Wdesk, you have to make sure you define what the number looks like. for example:F
    =NUMBERVALUE(C5,$###,##0). This will convert cell C5 into a number that is formatted like $100,000 
    0
  • Jeremy Shumilak
    Looks like the issue goes away if I remove the IFNA formula -- I can add the TRIM function as well but if the IFNA formula is present it doesn't help. Not sure what it is about this formula that Excel doesn't like as the spelling for the formula is the same in Workiva and Excel but I'll remove it. Thanks anyway!
    0

Accedi per aggiungere un commento.