EXCEL - PLUS IN BRACKETS
EXCEL - PLUS IN BRACKETS
(OP)
SILLY QUESTION.
IN A SIMPLE EQUATION WE WRITE =(A1+A2)
WHEN WE USE =(+A1+A2) WHY DOES IT STILL WORK AND WHAT IS THE FIRST + FOR.
SECOND PART. IF I HAVE HUNDREDS OF EQUATIONS AND INTRODUCE A NEW COLUMN AND WILL ALSO HAVE THAT AS PART OF THE SUM IN AN EQUATION IS THERE A WAY TO GLOBALLY CHANGE THE 100 EQUATIONS TO INCLUDE THE NEW COLUMN.
THANKS
IN A SIMPLE EQUATION WE WRITE =(A1+A2)
WHEN WE USE =(+A1+A2) WHY DOES IT STILL WORK AND WHAT IS THE FIRST + FOR.
SECOND PART. IF I HAVE HUNDREDS OF EQUATIONS AND INTRODUCE A NEW COLUMN AND WILL ALSO HAVE THAT AS PART OF THE SUM IN AN EQUATION IS THERE A WAY TO GLOBALLY CHANGE THE 100 EQUATIONS TO INCLUDE THE NEW COLUMN.
THANKS





RE: EXCEL - PLUS IN BRACKETS
Q2: Maybe, as it depends on the formula, and how it's specified. If the formula uses relative cell addressing, then a copy of one cell, and a paste into a large selection of cells will automatically adjust the relative cell addresses accordingly.
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
RE: EXCEL - PLUS IN BRACKETS
Cheers
Greg Locock
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: EXCEL - PLUS IN BRACKETS