excel functions - closing parenthesis

[Saqib]

To avoid errors in nested functions, I like to create a set of parenthesis() and then fill its content.
For example: To create an if function, I would first type =if() and then proceed to fill the brackets and I do the same with nested functions. The moment I type =If() and move curser left, excel gives me an error.

How do I get rid of the error?

 

[NARAYANK991]

Hi Saqib ,

This is the way Excel works ; when you press the closing parenthesis , Excel considers the function entry complete , and now any key press such as the TAB key , the UP / DOWN / LEFT / RIGHT cursor keys , ENTER key will generate an error , since Excel cannot move the cursor from the cell which has the IF formula. The only way out is to press the F2 key to remain in EDIT mode , and then press the LEFT arrow key , so that now the cursor will position itself between the two parentheses.

Narayan

 

[Debraj]

By the way..

Excel has one more great feature..

Pressing OK.. will place the cursor on the 1st error occurance or "missing mandatory parameter" location..

You can go-ahead.. by pressing OK.. and excel also has a magical way to detect.. "Missing Closing Parenthesis".. and with a WARNING message.. it automatically add the last closing brackets for you..

keep faith on EXCEL..