Report

If/Then Formula Help [Solved]

Ask a question MrJags 2Posts Friday December 16, 2016Registration date December 16, 2016 Last seen - Last answered on Dec 16, 2016 at 01:33 PM by MrJags
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 
Helpful
+0
moins plus
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.

MrJags 2Posts Friday December 16, 2016Registration date December 16, 2016 Last seen - Dec 16, 2016 at 01:33 PM
This worked perfectly!

Thanks BrianGreen!
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!