Excel Formula

[xsubzeroz]

I wanted to know if its possible to write formula to calculate in one cell and place that formula result in another cell. I also would like for the output cell to be empty so that I can type something there.

ex. A B C D E
1 20
2 10
3 15
4
Write a formula (sum of B1:B3)in cell B4 and display result in D4 but I would like to be able type in D4 so it can't contain any formulas. Please help me! Thank you.

 

[smah]

If I understand correctly, this isn't exactly what you want but will work:

In your example create the additional text (to be added to D4) somewhere else, let's say E13.

Formula for B4 =SUM(B1:B3)
Formula for D4 ==CONCATENATE(B4," ",E13)

 

[xsubzeroz]

Thanks for reply but that's not quite what I was looking for. See I have in cell B5 calculation that would give me a number if proper data is typed and #N/A if data not right. What I wanted to do is to type in one cell (for example C10) the formula that would say if cell B5 is #N/A then type in cell C9 same (#N/A) but if B5 is number then leave C9 empty. I don't want C9 to contain any formulas because I want to be able to type in that cell.

 

[xlbo]

AFAIK - this is not possible without code
A cell cannot show the result of a formula without some sort of formula being there Rgds
~Geoff~

 

[xsubzeroz]

Thanks "xlbo". I thought that probably that is not possible. The follow up question I posted before I read your answear so I guess I got my question answeared. Thank again.

 

[smah]

xsubzeroz,

The only other possibility is to create a formula in C9 =B5 (using the cells from your last example).

If B5 is #N/A then #N/A will also be displayed in C9. If B5 is a number, then that number will show up in C9, but you could just type over it to replace the formula with your text. To make the difference even more obvious, you could use conditional formatting on C9.

That's the best that I can come up with, sorry.