excel - IF Column F = TEXT THEN change Column G -


i'm sure simple i'm having difficult time getting right. basically, if column f equal text string, column g should show text string.

assuming data this:

     col f    col g 1    black 2    white 3    black 4 5    white 

your formula in col g should like:

=if(f1 = "black", "yes", if(f1 = "white", "no", if(f1 = "", "", ""))) 

using formula give you:

     col f    col g 1    black     yes 2    white     no 3    black     yes 4 5    white     no 

Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -