View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default IF statement not showing value

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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bob Phillips" wrote in message
...
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" wrote in message
...
Don't they have TiVo in G.B.?<bg
--

Regards,

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

"Bob Phillips" wrote in message
...
Not usually, but I was watching a (mildly) interesting film on TV (Robert
Carlyle and Ray Winstone).

Bob

"RagDyer" wrote in message
...
Are you an insomniac?<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
---------------------------------------------------------------------------
"Bob Phillips" wrote in message
...
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)


"mickey" wrote in message
...
Here is the formula:

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

"RagDyer" wrote:

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?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may
benefit
!
---------------------------------------------------------------------------
"mickey" wrote in message
...
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?