Thanks:  0
Likes:  0

1. 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. Try this =IF(N17>0,"LBS","")

3. 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. 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. 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. 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!

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

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.
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. On 2002-04-07 13:43, Yogi Anand wrote:
Hi Hawk:
I am glad it worked for you.

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.
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.

User Tag List

Posting Permissions

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