If/Then Formula Help

Solved/Closed
MrJags Posts 2 Registration date Friday December 16, 2016 Status Member Last seen December 16, 2016 - Dec 16, 2016 at 01:01 PM
MrJags Posts 2 Registration date Friday December 16, 2016 Status Member Last seen December 16, 2016 - Dec 16, 2016 at 01:33 PM
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 response

BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 149
Updated by BrianGreen on 16/12/16 at 01:14 PM
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)
0
MrJags Posts 2 Registration date Friday December 16, 2016 Status Member Last seen December 16, 2016
Dec 16, 2016 at 01:33 PM
This worked perfectly!

Thanks BrianGreen!
0