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