Excel Help...How to have cell keep the entere

August 18, 2011 at 15:36:55
Specs: Windows XP
Hello,

I don't understand how I can write a formula that would allow a cell to retain the entered value based on some other cell's value.

for example, I want cell values in column 2 to be 2000 if column 1's corresponding row's cell = 1 but, if this cell =0 then I want column 2's corresponding cell to keep the value already entered.

ie, If column 1, cell 1 = 1 then Column 2, cell 1 = 2000
If column 1, cell 1 = 0 then Column 2, cell 1 = "value I entered manually"

I tried following tries for Column 2 but failed...
1) IF ((A1=1), 2000,"$A1$2")
2) IF ((A1=1), 2000, "")

do you have any idea what formula in the false logic would allow user's manual input?

Nick


See More: Excel Help...How to have cell keep the entere

Report •


#1
August 18, 2011 at 17:34:01
You cannot have a formula and a "manual entry" in a cell at the same time.

Think about it. How could they both exist at the same time? Once you start typing either the formula or the manual entry, the other is gone.

What exactly is it that you are trying to do? There may be a way to force 2000 into a cell while also allowing manual entry by using VBA, but we would need some specifics as to what it is you are trying to accomplish.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
August 19, 2011 at 08:38:13
Hello Derby,

What I am trying to accomplish is have one y column dependent on another x column value and if x column value = 1. If x column value is 0 then y column should remain the same as entered.

ie. If I change X column from 0 to 1, then Y column = 20. If X column = 0, then I keep whatever value I entered in the Y column. Chane Y column value to 20 only if when X column is 0.

Nick


Report •

#3
August 19, 2011 at 14:08:26
re: "If I change X column from 0 to 1, then Y column = 20"

re: "Change Y column value to 20 only if when X column is 0."

Huh? Those 2 statements are the exact opposite of each other.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
August 22, 2011 at 15:32:49
I don't know how to explain, it's actually pretty easy but...I'll attempt it again. I'll simply keep it to 2 cells...cell 1 and cell 2

If cell 1 = 1 then cell 2 = 20. If cell 1 = 0 then let user can enter any values in cell 2.

I hope above helps :)

thanks again,

Nick


Report •

Ask Question