Thanks:  0
Likes:  0

# Thread: DISPLAY IN CELL

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

2. On 2002-04-07 14:44, Yogi Anand wrote:
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.

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!

4. On 2002-04-07 15:05, Yogi Anand wrote:
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","")

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

which excludes negative numbers altogether.

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

## 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
•