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