Forum Discussion

LCSALLES985's avatar
LCSALLES985
Copper Contributor
Jul 21, 2020

Error message _xlfn.SINGLE

I have been using the old logical functions if, and,or. They are accepted when inserted but after being filed, they show up with this error message that does not help me anyway given that the functions that I use are those mentioned above.

Here is an example:

'=SE(OU(_xlfn.SINGLE(_ida2)<_xlfn.SINGLE(_idaini);_xlfn.SINGLE(_ida2)>_xlfn.SINGLE(_idafim));_espa;SE(E(_xlfn.SINGLE(_tiev)="T";_xlfn.SINGLE(_ida2)>=_xlfn.SINGLE(_idaini);_xlfn.SINGLE(_ida2)<=_xlfn.SINGLE(_idafim));_xlfn.SINGLE(_valor);SE(E(_xlfn.SINGLE(_tiev)="U";_xlfn.SINGLE(_ida2)=_xlfn.SINGLE(_idaini));_xlfn.SINGLE(_valor);_espa)))

excel

8 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    Jul 21, 2020

    LCSALLES985  unfortunately I'm having problems reading your formula due to translation issues but try using ctrl-shift-enter.  Some of these legacy formulas handled arrays different than the new excel and so excel apparently has 'flagged' your formula as such.

    • LCSALLES985's avatar
      LCSALLES985
      Copper Contributor
      Jul 21, 2020
      Sorry for my English. Thank you and I will be back in a couple of hours.
      • mtarler's avatar
        mtarler
        Silver Contributor
        Jul 21, 2020

        LCSALLES985  your English was fine, it was just the formula itself that didn't translate, but from what I can interpret it appears you have a number of named ranges you are referencing and that is what Excel is having issue with.  Are those named ranges single cell or ranges or dynamic?  Did using ctrl-shift-enter fix the problem?

Resources