Excel

Z

Zapatera

How can I enter a value in a cell that contains a formula but without erasing
the formula?
 
F

FSt1

hi
you can't. entering a value would overwrite the formula.
you could do somthing like this..
=A1+A2 & 500 but that would turn the entire cell value to text and the
formula and value would be useless not to mention a waiste of time.

regards
FSt1
 
F

FSt1

hi again.
i think my brain skidded into a ditch. the formula i posted would work.
if 1 was in A1 and 2 in A2, the results would be 3500. (3 & 500)
also if you replace the apersand with a plus sign the result would be 503.

so it could be done. just depends would what results you want.

sorry for the confusion. my fault.

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keep formula in a cell? 1
Value or Formula 5
Date formatting error 1
Adding text without erasing previous text? 3
formula 3
Extending a selection 1
Excel VBA 1
Function to determine if a cell contains a formula 5

Top