# Dynamic IF formulas

#### Stanek93

##### New Member
Hi all,

I'm fairly new to excel, so I hope you can help me.

I have a large dataset with monthly tracking data. In one of the sheets i perform a lot of "conditional checks" (typically IF formulas).
The problem is, that when new variables are added to the data set, the IF formulas refer to the wrong variables.

Example:
I have =IF(B2>0;"OK";"Fail")
Now a new variable is added in column B, so my old B-variable is now located in column C.
The old IF formula should now automatically be =IF(C2>0;"OK";"Fail")

How can I do this?

Thanks.

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Replies
6
Views
167
Replies
6
Views
153
Replies
0
Views
60
Replies
3
Views
129
Replies
5
Views
114

1,133,791
Messages
5,660,946
Members
418,606
Latest member
Mbaxter

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back