locked
calculated column =Value(Right([Name],3)) - result #value! RRS feed

  • Question

  • I have a colume [Name] with following entries:

     

    asdf123

    qwer456

    gsdg789

    wer1

    gqw65

    qwer

     

    with the mentioned formula I can get the last 3 digits in the new column.

     

    the first 3 fields are correct, the rest just givs a #value! as a result

    how can I 'fix' this. it's okay if there is just a "0" or a "n.a." if there are not 3 numbers at the end.

     

    thx

     

     

    the first

    • Moved by Mike Walsh FIN Wednesday, August 24, 2011 2:25 PM admin q nt customization (From:SharePoint - Design and Customization (pre-SharePoint 2010))
    Wednesday, August 24, 2011 2:03 PM

Answers

  • Try this

    =IF(ISNUMBER(VALUE(RIGHT(Title,3))),VALUE(RIGHT(Title,3)),"n.a.")


    --Cheers
    Wednesday, August 24, 2011 2:16 PM