Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-564158%22%20slang%3D%22en-US%22%3E%3DIF((AND%20function%20resulting%20in%20number%20from%20other%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-564158%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20set%20up%20a%20IF%20AND%20formula%20will%20result%20is%20the%20number%20in%20a%20different%20cell.%26nbsp%3B%20I%20am%20using%20this%20as%20a%20for%20a%20mail%20merge%20letter.%26nbsp%3B%20So%20I%20want%20it%20to%20say%20that%26nbsp%3B%3DIF((AND(%24T%242%3D%22%22%2CU2%26lt%3B%26gt%3B%22%22))%2C%22%3CSTRONG%3E%3DU2%3C%2FSTRONG%3E)%22%2C%22%22)%20but%20the%26nbsp%3B%3CSTRONG%3E%3DU2%26nbsp%3B%3C%2FSTRONG%3EI%20want%20it%20to%20actually%20pull%20the%20number%20that%20is%20listed%20in%20U2%2C%20not%20show%20%3DU2.%26nbsp%3B%20Is%20this%20even%20possible%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-564158%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Megan James
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
Modify your formula to this:
=IF(AND($T$2=“”,U2<>””),
U2,””)
Thank you so much!!! :)
You’re very much welcome!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies