DISPLAY IN CELL - Page 2
Power Query Course in Spanish
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
    81,854
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 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
    81,854
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 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)!

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
  •  

 

 
DMCA.com