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

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.

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

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.

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

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History