Hi 

I need a formula(?) to swop the text in column A and B if column C has a 'Y' in it, like in the example below

Is this possible?

Thanks

Ivan

Hi 

I need a formula(?) to swop the text in column A and B if column C has a 'Y' in it, like in the example below

Is this possible?

Thanks

Ivan

In A2 the formula is:-

=IF(C2="y",B1,"C2 is not y")

In B2 the formula is:-

=IF(C2="y",A1,"C2 is not y")

Does the above give you what you want?

• Proposed as answer by trip_to_tokyo 21 hours 4 minutes ago
• Unproposed as answer by trip_to_tokyo 21 hours 4 minutes ago

Hi 

I need a formula(?) to swop the text in column A and B if column C has a 'Y' in it, like in the example below

Is this possible?

Thanks

Ivan

In A2 the formula is:-

=IF(C2="y",B1,"C2 is not y")

In B2 the formula is:-

=IF(C2="y",A1,"C2 is not y")

Does the above give you what you want?

• Proposed as answer by trip_to_tokyo Saturday, May 30, 2015 10:24 AM
• Unproposed as answer by trip_to_tokyo Saturday, May 30, 2015 10:24 AM
• Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator 2 hours 14 minutes ago

Hi 

I need a formula(?) to swop the text in column A and B if column C has a 'Y' in it, like in the example below

Is this possible?

Thanks

Ivan

In A2 the formula is:-

=IF(C2="y",B1,"C2 is not y")

In B2 the formula is:-

=IF(C2="y",A1,"C2 is not y")

Does the above give you what you want?

• Proposed as answer by trip_to_tokyo Saturday, May 30, 2015 10:24 AM
• Unproposed as answer by trip_to_tokyo Saturday, May 30, 2015 10:24 AM
• Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, June 01, 2015 5:13 AM

Hi

IF C1=Y then swop A1 with B1 (not in a new row), 

A1=Hello

B1=World

IF C1=y then make A1=World & B1=Hello

Does this make more sense? Thanks for you time and effort

Hi

IF C1=Y then swop A1 with B1 (not in a new row), 

A1=Hello

B1=World

IF C1=y then make A1=World & B1=Hello

Does this make more sense? Thanks for you time and effort

In A1:-

=IF(C1="y","World","Hello")

In B1:-

=IF(C1="y","Hello","World")

I can't think of any other way to do this without getting a Circular Reference.

You'll have to hard code what's in the cells into the formulae.

• Edited by trip_to_tokyo 11 hours 28 minutes ago
• Marked as answer by Ivan Davids 1 hour 17 minutes ago