Answered step by step
Verified Expert Solution
Question
1 Approved Answer
=IF(AND(_xlfn.SINGLE(O11) ,_xlfn.SINGLE(G11) ),HYPERLINK(whatsapp://send?phone=P2O2&&text=&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(R11,%,%25), ,%20),?, %3F),&,%26),=,%3D),{,%7B),},%7D),[,%5B),],%5D),Haz clic aqu),)
=IF(AND(_xlfn.SINGLE(O11)<>"",_xlfn.SINGLE(G11)<>""),HYPERLINK("whatsapp://send?phone=P2O2&&text="&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(R11,"%","%25")," ","%20"),"?", "%3F"),"&","%26"),"=","%3D"),"{","%7B"),"}","%7D"),"[","%5B"),"]","%5D"),"Haz clic aqu"),"")
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started