Bracket use

[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

 

[Ken Russell]

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

Ken Russell
Remove hat to reply by e-mail
(e-mail address removed)

| 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
|
|
| ---
| Message posted
|

 

[Guest]

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

 

[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

 

[Chapsta]

Thanks for the inf