Putting answer in different cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi ,

This may be quite simple but as me stumped, if I do a simple formula - A1 + B1 with the forumla in c1 how do I also get the answer to appear in a different cell i.e. D1 without putting a formula in d1
 
Hi
without using VBA no way!. You either have to put a formula in D1 -
e.g.: =IF(C1<>"",C1,"")
or use the worksheet_change event. I would recommend using the formula
approach
 
Hi Dennis

Without a formula you need VBA code to do it if you want.
You can add this in D1

=C1


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Dennis said:
Hi ,,

This may be quite simple but as me stumped, if I do a simple formula - A1 + B1 with the forumla in c1 how do I also get the
Click to expand...
answer to appear in a different cell i.e. D1 without putting a formula in d1
 
thanks for the answers, if I have to put in a formula I would prefer it to return the cell reference (i.e c1) is this possible

----- Ron de Bruin wrote: ----

Hi Denni

Without a formula you need VBA code to do it if you want
You can add this in D

=C


--
Regards Ron de Brui
(Win XP Pro SP-1 XL2000-2003
www.rondebruin.n



Dennis said:
Hi ,
Click to expand...
answer to appear in a different cell i.e. D1 without putting a formula in d
 
Hi Dennis
not sure what you mean. What is your desired result in D1 (the same
value as in C1?)
 
Sorry, I mean't if I can't have D1 displaying the same answer as C1, I need d1 to display"c1"....

----- Frank Kabel wrote: ----

Hi Denni
not sure what you mean. What is your desired result in D1 (the sam
value as in C1?

-
Regard
Frank Kabe
Frankfurt, German

Dennis wrote
 
Back
Top