Column Problem Help Please!
 

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,"Start",(IF(E4=$D5,"Finish","-")))

This formula works for all of the values, EXCEPT when It reaches column x,
this is the only column that won't display ""Finish" 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 "-".
Very Frustrating.

Thanks in advance for your help

Column Problem Help Please!
 

It seems to me that your formula is simply wrong? (could be me, tho!)
Try this:
=IF(E4=$C5,"Start",IF(E4=$D5,"Finish","-"))

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

"Alisonatwork" wrote in message
...
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,"Start",(IF(E4=$D5,"Finish","-")))

This formula works for all of the values, EXCEPT when It reaches column x,
this is the only column that won't display ""Finish" 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 "-".
Very Frustrating.

Thanks in advance for your help

Column Problem Help Please!
 

Hi Again,
no it didn't fix it, still a problem with the x column

So weird...

"Anne Troy" wrote:

It seems to me that your formula is simply wrong? (could be me, tho!)
Try this:
=IF(E4=$C5,"Start",IF(E4=$D5,"Finish","-"))

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

"Alisonatwork" wrote in message
...
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,"Start",(IF(E4=$D5,"Finish","-")))

This formula works for all of the values, EXCEPT when It reaches column x,
this is the only column that won't display ""Finish" 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 "-".
Very Frustrating.

Thanks in advance for your help