Thread: [Solved] Need help with IF formula
View Single Post
 
Old 01-19-2016, 06:28 AM
SMI SMI is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jan 2016
Posts: 3
SMI is on a distinguished road
Default 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?
Reply With Quote