I am currently using W8 and Excel 2010. I am trying to write what I thought was a straightforward "IF"
function for each cell in a column; whereby if a specific cell in the same row is blank, I want the cell containing the formula also to display blank. If not then I want a default text to appear. Here is my formula entered in F2
:
=If(A2="";"";"default text").
Column A contains a name and if it contains any text, then the default text is intended to be a hyperlinked address to the person's photograph on the same disk drive.
The problem is the formula won't work and it highlights ""
as being the error when trying to express blank.
Any help would be appreciated. Thanks.