writeing a formula in another cell

[MAHESHP030@GMAIL.COM]

i have sheet which contain following figures:-
column A column B column C column D column E
25 56 62
35 65 78
the problem is that the total of "A" "B" & "c" should come in column "D" but i want formula to be column "E"
is that possible
can a formula for column "d" can be written in column "E"
if anyone pls help

[FDibbins]

How about if you just put the formula in E instead of in D?
E1=A1+B1+C1

[:) Sixthsense :)]

What about this... lol

In E2 Cell

Please Login or Register  to view this content.

In D2 Cell

Please Login or Register  to view this content.

[MAHESHP030@GMAIL.COM]

No the result should be in column "d" but the formula must be in the column "e".

[:) Sixthsense :)]

Formula evaluates the result. In simple without VBA approach it is not possible

[FDibbins]

if you want the answer to be in D, but the formula to be in E (cant see why you would want this, but OK), put the formula in E
E1=A1+B1+C1
then format the text to be white, it will look like there is nothing there, then in D1
=E1

[MAHESHP030@GMAIL.COM]

I want formula in column "e" but result should be in column "d"
is that possible

[:) Sixthsense :)]

I want formula in column "e" but result should be in column "d"
is that possible

It seems that again you are redirecting to Post #1

[FDibbins]

OK, you have been given a few different suggestion, none seem to be what you want.

I suggest that you give more detailed explanation into what you want, what you are doing, and what your expected outcome would be - otherwise we are just guessing

[dilipandey]

Hi Mahesh,

In column F put the formula, copy that, select column E, do paste special -> link

Or

You can put the formula in column E only and then do copy paste special values - either manually or through vba (macros)



Regards,
DILIPandey
<click on below * if this helps>

[Ace_XL]

In Col F
=SUM(A1:D1)

In Col E
=F1

[MAHESHP030@GMAIL.COM]

THANKS BUT "F" SHOULD REFER TO COLUMN "E"
AND NOTHING SHOULD BE WRITTEN IN COLUMN "E" NOT EVEN "=F1"
CAN THIS FORMULA BE WRITTEN.

[arlu1201]

Mahesh,

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. I have merged your threads into 1. Please remember in future not to duplicate threads.

[:) Sixthsense :)]

Do right click on the sheet tab and select view code and paste the below code.

Please Login or Register  to view this content.

Whenever any value entered in in Column-A to Column-C then you will get the sum of value in Column-D.

[Fotis1991]

MAHESHP030@GMAIL.COM

You insist to ignore our request to don't post duplicate threads. Have you ever thought that we'll start to ignore your threads?

http://www.excelforum.com/excel-form...anwer-yet.html