If/Then Formula Help [Solved/Closed]

MrJags 2 Posts Friday December 16, 2016Registration date December 16, 2016 Last seen - Dec 16, 2016 at 01:01 PM - Latest reply: MrJags 2 Posts Friday December 16, 2016Registration date December 16, 2016 Last seen
- 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"?
See more 

2 replies

BrianGreen 955 Posts Saturday January 17, 2015Registration dateModeratorStatus April 16, 2018 Last seen - Updated by BrianGreen on 16/12/16 at 01:14 PM
0
Thank you
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 2 Posts Friday December 16, 2016Registration date December 16, 2016 Last seen - Dec 16, 2016 at 01:33 PM
This worked perfectly!

Thanks BrianGreen!