Problem with IF condition

[ChrisSingle]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am trying to write an IF condition in excel, but somehow don’t seem to manage to get it to work. <o></o>
I want Cell C37 to automatically fill its content depending on the choice in Cell B37, which has a drop down menu with “setting off from”, “arrive at” and “collect from” (B38, B39 and B40). <o></o>
If “setting off from” then the content of C35 should move to C37<o></o>
If “arrive at” or “collect from” then the content of G35 should move to C37<o></o>
<o></o>
I have written<o></o>
=IF(B37="setting off from";C37=C35;IF(B37=”arrive at”;C37=G35;IF(B37=”collect from”;C37=G35;"false")))<o></o>
<o></o>
But not sure why its not working<o></o>
<o></o>
Many thanks in advance for your help<o></o>
<o></o>

Chris Single

 

[el_ja]

If I understand correctly you're using the formula in the cell C37, in that case you don't need to put C37=C35 only C35
So the formula is:
=IF(B37="setting off from";C35;IF(B37=”arrive at”;G35;IF(B37=”collect from”;G35;"false")))

Assuming that's what you're doing.

 

[Scott Huish]

=IF(B37="setting off from",C35,IF(OR(B37={"arrive at","collect from"}),G35))

 

[chrysti]

Try this:
=IF(B37="setting off from",C35,IF(B37="arrive at",G35,IF(B37="collect from",G35,FALSE)))

I think this will get you what you are looking for.

 

[ChrisSingle]

el_ja

Thank you for your very quick reply!

That has solved the problem.

Cheers

 

[ChrisSingle]

Hotpepper & Christy,

thank you problem solved!