Forum Discussion
Create IF Formula with Hyperlink
Hello! I am having a problem creating a formula. I want the cell to pull information from a hyperlinked cell. That hyperlink will either have a number or be blank. I want the formula to return an...
Thanks Eva, I appreciate the help. It came to be that I truly did not need a hyperlink in the formula and that was what was throwing me off. I used the following formula and it worked great:
=IF(ISBLANK(A,1),"n/a",A,1)
I was trying to over complicate the formula!
Thanks Again!
Hi Carol! Great!! Was a pleasure, give a Like 😊! Have a nice Weekend. Greets, Eva