DISPLAY IN CELL

HAWK

New Member
Joined
Mar 24, 2002
Messages
19
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
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Paul B,

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

Any other ideas? I appreciate your time
 
Upvote 0
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","")
 
Upvote 0
you tried =IF(N17>0,"LBS","")
try the opposite

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

I had a similar problem and it worked for me

Polly
 
Upvote 0
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!
 
Upvote 0
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!
 
Upvote 0
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.
 
Upvote 0
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!
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top