If/Then Formula Help [Solved/Closed]

Report
Posts
2
Registration date
Friday December 16, 2016
Status
Member
Last seen
December 16, 2016
-
MrJags
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"?

3 replies

Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
October 2, 2019
208
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)
MrJags
Posts
2
Registration date
Friday December 16, 2016
Status
Member
Last seen
December 16, 2016

This worked perfectly!

Thanks BrianGreen!