If/Then Formula Help [Solved/Closed]

Report
Posts
2
Registration date
Friday December 16, 2016
Status
Member
Last seen
December 16, 2016
-
Posts
2
Registration date
Friday December 16, 2016
Status
Member
Last seen
December 16, 2016
-
Hello,

I could use some help on the formula below.
I need cells in one column (Y) to show specific text ("SEND") if cells in another column (G) has a specific name ("Gerald").

This is the formula I entered for column Y:
=if(G5:G13="Gerald Martin","SEND")

I've figured this part out but how do I make the others cells show as blank instead of "FALSE"?

1 reply

Posts
1004
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 27, 2020
135
Hi MrJags,

Im not an excel guru and I cant test this as I dont have excel installed on my pc here in the office,but here is what I would try. Im not sure if it is the best or most efficient way, but I would use the if/else statement. Something like ...

=if(G5:G13="Gerald Martin","SEND","")

Explenation ... if G5:G13 = "Gerald Martin", then "send" is printed (that stated after the first comma, else i(if G5:G13 is not "Gerald Martin) nothing is printed (that stated after the second comma).

Please let me know if it works.

I really appreciate thank you messages as a payment for solving issues   :o)
Posts
2
Registration date
Friday December 16, 2016
Status
Member
Last seen
December 16, 2016

This worked perfectly!

Thanks BrianGreen!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!