Dynamic IF formulas

[Stanek93]

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.

 

[HackSlash]

Add new columns on the right instead of the left.