DISPLAY IN CELL

[HAWK]

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

 

[Yogi Anand]

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

 

[Aladin Akyurek]

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.

 

[Yogi Anand]

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!

 

[Aladin Akyurek]

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

 

[Yogi Anand]

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