• 517K Members
• 3,647 Online
• 615K Conversations

New Contributor

# =IF((AND function resulting in number from other cell

Hi,

I am trying to set up a IF AND formula will result is the number in a different cell.  I am using this as a for a mail merge letter.  So I want it to say that =IF((AND(\$T\$2="",U2<>"")),"=U2)","") but the =U2 I want it to actually pull the number that is listed in U2, not show =U2.  Is this even possible?

3 Replies
Highlighted

# Re: =IF((AND function resulting in number from other cell

=IF(AND(\$T\$2=“”,U2<>””),
U2,””)

# RE: =IF((AND function resulting in number from other cell

Thank you so much!!! :)

# Re: RE: =IF((AND function resulting in number from other cell

You’re very much welcome!
Related Conversations
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
Translation problem on Transifex
Duran Hsieh in Localization Feedback on
2 Replies
Which formula to use
Ramon Haagen in Excel on
2 Replies