Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: DISPLAY IN CELL

  1. #11
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Aladin:
    Using the formula
    =if(N17,"LBS","")
    any entry in cell N17, even a text entry will result in LBS -- Hawk wants that to happen, if N17 houses a numeric entry >0

    Regards

  2. #12
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-07 14:44, Yogi Anand wrote:
    Hi Aladin:
    Using the formula
    =if(N17,"LBS","")
    any entry in cell N17, even a text entry will result in LBS -- Hawk wants that to happen, if N17 houses a numeric entry >0

    Regards
    Just put "Yogi" in N17 to see whether you really get LBS as result.

  3. #13
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Aladin:
    My apologies, for having been really messed up in last couple of exchanges with you -- the formula in question is not if(N17,"LBS","")-- this creates some other problems.
    Your suggested formula =if(LEN(N17),"LBS","")
    would give LBS correctly for all numeric entries, but will also give LBS for any text entry. That's why we need =IF(AND(ISNUMBER(N17),N17>0),"LBS","") to ensure we get LBS only with a numeric entry that's >0

    Regards!


  4. #14
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-07 15:05, Yogi Anand wrote:
    Hi Aladin:
    My apologies, for having been really messed up in last couple of exchanges with you -- the formula in question is not if(N17,"LBS","")-- this creates some other problems.
    Your suggested formula =if(LEN(N17),"LBS","")
    would give LBS correctly for all numeric entries, but will also give LBS for any text entry. That's why we need =IF(AND(ISNUMBER(N17),N17>0),"LBS","") to ensure we get LBS only with a numeric entry that's >0

    Regards!
    Yogi,

    We had a smilar discussion much earlier.

    The OP said;

    IF N17 CONTENTS IS A NUMBER, I WANT TO
    DISPLAY LBS IN O17. THIS IS FOR A SHIPPER
    N17 BEING THE PRODUCT WEIGHT. IF N17(WHICH CONTAINS A FORMULA OF WEIGHT CALCULATION FOR PRODUCT SHIPPED)DISPLAY BLANK I WOULD LIKE
    NOTHING DISPLAYED IN O17


    which does not explicitly exclude 0.

    Since 0 is a number, also its presence should lead to "LBS" as result. This reasoning motivates my:

    =IF(LEN(N17),"LBS","")

    under the assumption that N17 is guaranteed either to be blank or to house a number including 0. A blank can be more often than not a formula-generated blank, whence my bias towards using LEN.

    If a 0 should not lead to "LBS" and N17 is guaranteed to be empty (not a formula-genrated blank) or to house a number, I'd prefer using

    =IF(N17,"LBS","")

    instead of:

    =IF(ISNUMBER(N17),N17>0),"LBS","")

    which excludes negative numbers altogether.

    Aladin

  5. #15
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Aladin:
    This is my last post on this issue -- (I hope!). So, I will settle for the following formula:
    =IF(N(N17),"LBS","")
    This fulfills all the requirements to my understanding (and my liking)!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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