G
Guest
I WANT TO SHOW THE ANSWER TO A SUM TO SHOW IN A NONE RELATED CELL.IE:FORMULA SET IN C1=SUM(A1+B2) ANSWER TO SHOW IN D1.CAN THIS BE DONE,IF SO CAN ANYONE SHOW ME HOW.
J
John Wilson
Wyn,
Not without using a macro.
You can't change a cell with a formula from another cell.
You could use
=C1
in
D1
John
DONE,IF SO CAN ANYONE SHOW ME HOW.
Not without using a macro.
You can't change a cell with a formula from another cell.
You could use
=C1
in
D1
John
CELL.IE:FORMULA SET IN C1=SUM(A1+B2) ANSWER TO SHOW IN D1.CAN THIS BEWYN BUNSTON said:
DONE,IF SO CAN ANYONE SHOW ME HOW.
N
Norman Harker
Hi Wyn!
A formula or function can only return a value to the cell it is in. A
formula can't change the Excel environment.
See:
170787 XL: Custom Functions Can't Change Microsoft Excel Environment
http://support.microsoft.com/default.aspx?scid=kb;en-us;170787
To do what you want will require VBA.
You shouldn't use all upper case. It's more difficult to read
especially for those whose first language isn't the one used. It's
also considered to be shouting, which is rude.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
DONE,IF SO CAN ANYONE SHOW ME HOW.
A formula or function can only return a value to the cell it is in. A
formula can't change the Excel environment.
See:
170787 XL: Custom Functions Can't Change Microsoft Excel Environment
http://support.microsoft.com/default.aspx?scid=kb;en-us;170787
To do what you want will require VBA.
You shouldn't use all upper case. It's more difficult to read
especially for those whose first language isn't the one used. It's
also considered to be shouting, which is rude.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
CELL.IE:FORMULA SET IN C1=SUM(A1+B2) ANSWER TO SHOW IN D1.CAN THIS BEWYN BUNSTON said:
DONE,IF SO CAN ANYONE SHOW ME HOW.
K
Ken Wright
When you say non-related, do you truly mean that in the way we understand it.
What you have outlined could be done by simply having =C1 in D1 (But would be
related in my understanding of the term), but if you can elaborate on what it is
you are trying to achieve, then we may be able to help.
Also, please don't type in Caps, as it makes it very hard to read, thanks.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------
ME HOW.
What you have outlined could be done by simply having =C1 in D1 (But would be
related in my understanding of the term), but if you can elaborate on what it is
you are trying to achieve, then we may be able to help.
Also, please don't type in Caps, as it makes it very hard to read, thanks.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------
SET IN C1=SUM(A1+B2) ANSWER TO SHOW IN D1.CAN THIS BE DONE,IF SO CAN ANYONE SHOWWYN BUNSTON said:
ME HOW.