I have a spreadsheet which has two worksheets.
Worksheet 1 and Worksheet 2
On Worksheet 2 in Cell B10, i have Product Name - and the formula ='Sheetn'!C11
when i enter data in Sheetn Cell 11 - e.g 'Book'
This data is displayed on the Worksheet 2.
However, When data is not Input in C11, (there is nothing in cell and it is blank)
Why do i get the Value '0' displayed in Worksheet 2 ? How do i get a Blank value where there is nothing there.
Thank You.
Last edited by markhuges; 11-05-2011 at 05:18 AM.
use
=IF(LEN(Sheetn!C11)>0,Sheetn!C11,"") instead of =Sheetn!C11
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Thanks i will try that later but what doesOriginally Posted by Azam Ali
LEN mean? Thanks
it is calculating no of characters in cell # C11
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks