Need help with IF formula
Hi Macropod
Many thanks for your help. I got luck with the 2nd option you have shared. It works as expected.
However with the If condition I am either getting a syntax error or there is no result. Note that I am first pressing CTRL+F9 and then inserting the formula in your suggestion that begins with IF up till the final quotation mark. I guess I am making some mistake because you have mentioned that all braces are field braces. Does it mean that all the other braces in between should also be inserted using above keyboard shortcut?
|