| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement not showing value
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
How do you know that it is valid and calculates correctly if an answer is not
displayed? What is showing in the cell? -- -John Please rate when your question is answered to help us and others know what is helpful. "mickey" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
I have the same formula in two identical workbooks. One works, one does not.
"John Bundy" wrote: How do you know that it is valid and calculates correctly if an answer is not displayed? What is showing in the cell? -- -John Please rate when your question is answered to help us and others know what is helpful. "mickey" wrote: 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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
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! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
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? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
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? |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
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? |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
Sorry.
I'm not getting the "(Project ID Here)" "RagDyer" wrote: 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! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "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? |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
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. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mickey" wrote in message ... Sorry. I'm not getting the "(Project ID Here)" "RagDyer" wrote: 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! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "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? |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
Crikey, 250 hours, how big is that HDD?
Bob "RagDyer" wrote in message ... 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? |
|
#16
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF statement not showing value
Good question.
Their marketing strictly centers around "time-wise" capacity, with no mention what-so-ever as to actual HD size. -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Bob Phillips" wrote in message ... Crikey, 250 hours, how big is that HDD? Bob "RagDyer" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL concatenation statement | Excel Discussion (Misc queries) | |||
| Can't add 7th IF statement to long formula. | Excel Worksheet Functions | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Linear Mode
