IF statement not showing value

[Guest]

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?

 

[Guest]

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

 

[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?

 

[Guest]

I have the same formula in two identical workbooks. One works, one does not.

 

[Guest]

Here is the formula:

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

 

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

 

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

 

[RagDyer]

Are you an insomniac?<g>

 

[Bob Phillips]

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

Bob

 

[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

 

[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

 

[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.

 

[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.

 

[Bob Phillips]

Crikey, 250 hours, how big is that HDD?

Bob

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.

 

[RagDyeR]

Good question.

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