# If Function – If False Do Nothing

The IF function has the following syntax:

IF(logical_test,value_if_true,value_if_false)

My questions is,
If I don’t want the function to take any action in the case of the logical test is false, what do I write in the “value_if_false” field?

In short, I need the already existing value in the cell to remain as is, if the IF function tests false.

### 5 thoughts on “If Function – If False Do Nothing”

1. Excel Geek

Hi

Have you tried specifying the cell for the value if false option?

So for example, if cell A1 contains the number 1, cell B2 would contain the following formula:

`=IF(A1=1,"Yes",A1)`

So if cell A1 contains anything other than the number 1 then cell B1 will display the same value as A1. Obviously this is a simplified example, and you could base it on calculations as well.

Hope this helps.

Thanks for writing.

2. CM

Hi

I did try naming the same cell (A1) in the false field. It gives me a circular reference error but the value does however get retained.

Now the issue is with another cell A2, whose value depends on the value of A1(after a formula calculation in A2), which does not compute. I tried fiddling with the formula for A2 and it still does not work.

Finally, I tried to check what actual value of A1 that was received at A2. I used the formula (= A1) in A2. The value showed “0” in A2. The value in A1 at the time showed 19.

In short
A1 Shows 19 (after circular reference error)
A2 = A1
Now A2 Shows 0

Any suggestions?

3. PFit

Hi CM, Excel Geek ðŸ™‚
Suggest getting rid of the circular reference, … use a second column to do the logic, the first column to hold the values.

Row Column A Column B
1 3 If(A1>2,1,A1) â€¦ answer is 1
2 =B1+4 â€¦ answer is 5
3

You can always hide the column you don’t want to see.

4. Jessi Timko

This site is just awesome. I’ve ask these info a long time and I view it that is good written, easy to understand.
I congratulate you because of this research that I’ll tell to the people around.
I ask you to go to the gpa-calculator.co site where
each university student or learner can find results grade point average
marks. Success!