Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: DISPLAY IN CELL

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    LIZ
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this =IF(N17>0,"LBS","")

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    LIZ
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Paul B,

    I tried =IF(N17>0,"LBS","")
    It does display LBS still if N17 is blank

    Any other ideas? I appreciate your time

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,045
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-04-07 09:11, HAWK wrote:
    Paul B,

    I tried =IF(N17>0,"LBS","")
    It does display LBS still if N17 is blank

    Any other ideas? I appreciate your time
    What is N17: A formula that either produces a number or a blank? If so,

    in O17 enter:

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


  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Williston ND
    Posts
    55
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you tried =IF(N17>0,"LBS","")
    try the opposite

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

    I had a similar problem and it worked for me

    Polly

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

    Default

    On 2002-04-06 17:14, HAWK wrote:
    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
    Hi Hawk:
    I think you have posted the same question, several times before -- wherein PaulB , smozgur, and myself posted response to your question. If you post the same question several times, you will get fragmented responses

    Have you tried my solution that I gave to your question

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

    Please post back if it works for you ... otherwise explain a little further and let us take it from there!


    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  7. #7
    New Member
    Join Date
    Mar 2002
    Location
    LIZ
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    YOGI ANAND,

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


    THIS DID WORK. I APOLOGISE FOR NOT REPLYING
    SOONER. YOU HAVE NO IDEA HOW MUCH YOUR INPUT
    HAS HELPED ME.

    THANKS AGAIN!

  8. #8
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,045
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-04-07 12:31, HAWK wrote:
    YOGI ANAND,

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


    THIS DID WORK. I APOLOGISE FOR NOT REPLYING
    SOONER. YOU HAVE NO IDEA HOW MUCH YOUR INPUT
    HAS HELPED ME.

    THANKS AGAIN!
    Try also the shorter formula built with LEN.

  9. #9
    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 Hawk:
    I am glad it worked for you.

    Hi Aladin:
    On 2002-04-07 12:57, Aladin Akyurek wrote:
    On 2002-04-07 12:31, HAWK wrote:
    YOGI ANAND,

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


    THIS DID WORK. I APOLOGISE FOR NOT REPLYING
    SOONER. YOU HAVE NO IDEA HOW MUCH YOUR INPUT
    HAS HELPED ME.

    THANKS AGAIN!
    Try also the shorter formula built with LEN.
    Hi Aladin:
    Your formula is really short and sweet, but it takes care of the situation when there is no entry in N17, however, Hawk's original question is

    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
    I interpret his requirement as that he wants the entry LBS to show up in O17 only if there is a numeric entry >0 in cell N17!

    Regards!

  10. #10
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,045
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-04-07 13:43, Yogi Anand wrote:
    Hi Hawk:
    I am glad it worked for you.

    Hi Aladin:
    On 2002-04-07 12:57, Aladin Akyurek wrote:
    On 2002-04-07 12:31, HAWK wrote:
    YOGI ANAND,

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


    THIS DID WORK. I APOLOGISE FOR NOT REPLYING
    SOONER. YOU HAVE NO IDEA HOW MUCH YOUR INPUT
    HAS HELPED ME.

    THANKS AGAIN!
    Try also the shorter formula built with LEN.
    Hi Aladin:
    Your formula is really short and sweet, but it takes care of the situation when there is no entry in N17, however, Hawk's original question is

    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
    I interpret his requirement as that he wants the entry LBS to show up in O17 only if there is a numeric entry >0 in cell N17!

    Regards!
    If so,

    =IF(N7,"LBS","")

    would suffice.

    Aladin

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
  •