Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Curly Brackets
I have this snippet of code as part of a larger formula:
IF(AND($N4="IT1L",OR($O4={"ACQ","ERM","MOF","MOR", "PRO"},$S40)),($AF$4+ $AG$4+$AH$4)/5*7+$AI$4+$AJ$4,0) I cannot remember how I was able to insert the curly brackets in the OR formula above... It does not work for me when I do CTR+SHIFT+ENTER or when I simply use the "{" and "}" symbols and press ENTER. -- tb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Curly Brackets
Hi,
Am Thu, 25 Apr 2013 16:05:02 +0000 (UTC) schrieb tb: IF(AND($N4="IT1L",OR($O4={"ACQ","ERM","MOF","MOR", "PRO"},$S40)),($AF$4+ $AG$4+$AH$4)/5*7+$AI$4+$AJ$4,0) into the formula you have to write the curly brackets. CTRL+Shift+Enter is to enter an array formula and will set the curly brackets to the start and the end of the formula. Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Curly Brackets
On 4/25/2013 at 11:08:01 AM Claus Busch wrote:
into the formula you have to write the curly brackets. CTRL+Shift+Enter is to enter an array formula and will set the curly brackets to the start and the end of the formula. Regards Claus Busch Thanks, Claus! -- tb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct error caused by too many curly brackets? | Excel Worksheet Functions | |||
Inserting curly brackets within a formula | Excel Worksheet Functions | |||
Getting rid of curly brackets within formula | Excel Worksheet Functions | |||
Getting rid of curly brackets within formula | Excel Worksheet Functions | |||
Getting rid of curly brackets within formula | Excel Worksheet Functions |