IF Formulas that can return same value

[Napolo]

Is there a way to create an IF statement that will locate a cell and if they find text to return something particular or keep the current value?

My IF statements are rusty.

EXAMPLE:

ColumnA ColumnB
Description Contact Type
Travel A
Session A

In Column B, I am trying to enter the below.
=IF(A2="Travel","K",B2)


Ultimately changing column B to the below:
Description Contact Type
Travel K
Session A


Hope this makes sense.

 

[dreid1011]

You could use that formula in col C to provide the K result. Otherwise, you cannot have a formula and a manually entered value in the same cell. Also, formulas cannot change cells other than the cell they are placed in.

If A is a given value, you COULD use your formula like this in col B:

=IF(A2="Travel","K","A")

If A is a manually entered value, then you would need to use the formula in col C or elsewhere.

 

[Napolo]

Ok that makes sense.

How about if I use the below and if the K1 is blank, how do i return a blank field? Right now it is pulling in a zero.

=IF(A1="Travel","K",K1)

 

[dreid1011]

You could modify it like so:

=IF(A1="Travel","K",IF(K1="","",K1))

 

[Scott Huish]

If K1 would contain text values and not numbers, then this would also work:

=IF(A1="Travel","K",T(K1))

 

[Napolo]

You could modify it like so:

=IF(A1="Travel","K",IF(K1="","",K1))

This worked perfectly. Thank you!!

 

[dreid1011]

You're welcome.