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
This message was edited by HAWK on 2002-04-06 20:37
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
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

O17:
=IF(LEN(N17)=0,"",N17)

This is much better
=IF(ISNUMBER(N17),N17,"")
Hi there Hawk and smozgur:
Smorguz, I believe you had earlier posted

=if(N17>0,"LBS","") ... which worked fine for numeric entry

I believe you now want to replace it with

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

to take care of any defiant text entry

Regards!

_____________
Yogi Anand
Edit: Deleted inactive web site reference from hard code signature line
This message was edited by Yogi Anand on 2003-01-19 17:35
 
Upvote 0
My apologies!
It was Paul B who had posted
=if(N17>0,"LBS","")
to the same question from Hawk that was duplicated.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,273
Members
448,559
Latest member
MrPJ_Harper

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