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

Highlighted
New Contributor

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
Modify your formula to this:
=IF(AND($T$2=“”,U2<>””),
U2,””)
Highlighted
Thank you so much!!! :)
You’re very much welcome!