IF statement not showing value

M

mickey

A valid IF statement exists in the cell formula however, the result does not
display. It does exist and calculates correctly, just no display.

Any help?
 
J

John Bundy

How do you know that it is valid and calculates correctly if an answer is not
displayed? What is showing in the cell?
 
R

RagDyer

Usually a data type problem.

Care to share the formula and any other information as to whether or not the
data is populated into the cells by keying, formula (what's the formula), or
import?
 
B

Bob Phillips

Perhaps the cell has a space or spaces. Try

=IF(TRIM(Info!B1)="","(Project ID Here)",Info!B1)


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
R

RagDyer

Which result are you *not* getting?
The "(Project ID Here)",
OR
The contents of B1?

You didn't answer my question as to how the cell (B1) is populated!
 
B

Bob Phillips

Not usually, but I was watching a (mildly) interesting film on TV (Robert
Carlyle and Ray Winstone).

Bob
 
R

RagDyeR

Don't they have TiVo in G.B.?<bg>
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Not usually, but I was watching a (mildly) interesting film on TV (Robert
Carlyle and Ray Winstone).

Bob
 
B

Bob Phillips

I have no idea, I don't know what it is. I do have a recordable DVD if that
is the sort of thing, but it is already full of stuff that I have yet to
watch (I need a RAID array of disks <g>)

Bob
 
R

RagDyer

You still didn't answer as to how the data gets into B1.

Maybe B1 is *not* empty.

If the data is keyed in, could there mistakenly be <spaces> entered?
(Did you try Bob's suggested formula!)

If the data is the return of a formula, could the formula be constructed
wrong, so that it returns " " instead of ""?
(Did you try Bob's suggested formula!)

If the data is imported, could there be the possibility that there are
invisible characters [CHAR(160)]?
Try this in another cell:
=Code(B1)
If you get the #VALUE error, you know B1 is either truly empty or it
contains a zero length string ("").
If a number is returned, you know that the cell contains that Char()
character.
 
R

RagDyer

Yes, that's what TiVo is ... with auto recording by program name.
And I have the same problem as you.
My first one had a capacity of 36 hours.
The next one had 100 hours.
I've just picked up a new one with 250 hours.
 
B

Bob Phillips

Crikey, 250 hours, how big is that HDD?

Bob


RagDyer said:
Yes, that's what TiVo is ... with auto recording by program name.
And I have the same problem as you.
My first one had a capacity of 36 hours.
The next one had 100 hours.
I've just picked up a new one with 250 hours.
Click to expand...
 
R

RagDyeR

Good question.

Their marketing strictly centers around "time-wise" capacity, with no
mention what-so-ever as to actual HD size.
 
Top