software

Hi,
I am creating a spreadsheet for work in which the start and finish times for
employees are recorded. I am using the following formula:
=IF(E4=$C5,quot;Startquot;,(IF(E4=$D5,quot;Finishquot;,quot;-quot;)))

This formula works for all of the values, EXCEPT when It reaches column x,
this is the only column that won't display quot;quot;Finishquot; in it. is there some
reason it won't recognise x as being the column name? how can I get around
this. At the moment it won't register anything in column x, except quot;-quot;.
Very Frustrating.

Thanks in advance for your helpIt seems to me that your formula is simply wrong? (could be me, tho!)
Try this:
=IF(E4=$C5,quot;Startquot;,IF(E4=$D5,quot;Finishquot;,quot;-quot;))

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Alisonatworkquot; gt; wrote in message
...
gt; Hi,
gt; I am creating a spreadsheet for work in which the start and finish times
gt; for
gt; employees are recorded. I am using the following formula:
gt; =IF(E4=$C5,quot;Startquot;,(IF(E4=$D5,quot;Finishquot;,quot;-quot;)))
gt;
gt; This formula works for all of the values, EXCEPT when It reaches column x,
gt; this is the only column that won't display quot;quot;Finishquot; in it. is there some
gt; reason it won't recognise x as being the column name? how can I get
gt; around
gt; this. At the moment it won't register anything in column x, except quot;-quot;.
gt; Very Frustrating.
gt;
gt; Thanks in advance for your help
gt;
Hi Again,
no it didn't fix it, still a problem with the x column

So weird...

quot;Anne Troyquot; wrote:

gt; It seems to me that your formula is simply wrong? (could be me, tho!)
gt; Try this:
gt; =IF(E4=$C5,quot;Startquot;,IF(E4=$D5,quot;Finishquot;,quot;-quot;))
gt;
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;Alisonatworkquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; I am creating a spreadsheet for work in which the start and finish times
gt; gt; for
gt; gt; employees are recorded. I am using the following formula:
gt; gt; =IF(E4=$C5,quot;Startquot;,(IF(E4=$D5,quot;Finishquot;,quot;-quot;)))
gt; gt;
gt; gt; This formula works for all of the values, EXCEPT when It reaches column x,
gt; gt; this is the only column that won't display quot;quot;Finishquot; in it. is there some
gt; gt; reason it won't recognise x as being the column name? how can I get
gt; gt; around
gt; gt; this. At the moment it won't register anything in column x, except quot;-quot;.
gt; gt; Very Frustrating.
gt; gt;
gt; gt; Thanks in advance for your help
gt; gt;
gt;
gt;
gt;