+ Reply to Thread
Results 1 to 3 of 3

Having a cell with '<' sign included within a function?

  1. #1
    Michelle
    Guest

    Having a cell with '<' sign included within a function?

    If there is a '<' sign in a cell, can the cell be included in a function?


  2. #2
    Bernard Liengme
    Guest

    Re: Having a cell with '<' sign included within a function?

    Not when the function expects a numeric value.
    You could use MID(A30,2,LEN(A30)-1) in place of just A3 which has <5.
    For example SQRT(MID(A30,2,LEN(A30)-1))
    or 2*MID(A30,2,LEN(A30)-1) which is not a function but a formula.
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "Michelle" <Michelle@discussions.microsoft.com> wrote in message
    news:46BBCC6F-BB0C-442B-81C9-57775C9F327E@microsoft.com...
    > If there is a '<' sign in a cell, can the cell be included in a function?
    >




  3. #3
    Harlan Grove
    Guest

    Re: Having a cell with '<' sign included within a function?

    Bernard Liengme wrote...
    >Not when the function expects a numeric value.
    >You could use MID(A30,2,LEN(A30)-1) in place of just A3 which has <5.
    >For example SQRT(MID(A30,2,LEN(A30)-1))
    >or 2*MID(A30,2,LEN(A30)-1) which is not a function but a formula.
    >best wishes


    If you want short, MID(x,2,1024) would give the same result. If you
    want simple, SUBSTITUTE(x,"<","") would give the same result. On the
    other hand, if all the '<' is supposed to achieve is a visual display,
    and the remainder of the cell's contents would be numeric, there's also
    the possibility of using a custom number format like "\<General". Then
    such cells could be used directly in other formulas while also
    displaying as desired.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1