Bracket use

C

Chapsta

Hi,

I'm trying to reproduce a calculation that is on a spreadsheet I hav
been emailed by a former employee.

The calculation starts {=Sum(..... and ends ....,0))} I'm not sure wha
the {} mean and how to replicate them in another spreadsheet.

Any help would be appreciated.

Chapst
 
K

Ken Russell

Ignore them. They seem to change the formula to text.

Ken Russell
Remove hat to reply by e-mail
[email protected]

| Hi,
|
| I'm trying to reproduce a calculation that is on a spreadsheet I have
| been emailed by a former employee.
|
| The calculation starts {=Sum(..... and ends ....,0))} I'm not sure what
| the {} mean and how to replicate them in another spreadsheet.
|
| Any help would be appreciated.
|
| Chapsta
|
|
| ---
|
|
 
U

unlikeKansas

This indicates that the formula is an array formula:

A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { }, and are entered by pressing CTRL+SHIFT+ENTER.), Microsoft Excel automatically inserts the formula between { } (braces).

See Excel Help Array for more info.

unlikeKansas
 
B

Biff

Hi Chapsta!

The squiggly braces {} denote an array formula. Excel
applies them when you write your formula then, instead of
hitting ENTER, you hold down the keys CTRL SHIFT and then
hit ENTER. You cannot just type them in.

Write your formula then hit CTRL,SHIFT,ENTER.

Biff
 
Top