Dynamic IF formulas

Stanek93

New Member
Joined
Jan 10, 2017
Messages
1
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.
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,099,115
Messages
5,466,766
Members
406,497
Latest member
Bryanlim

This Week's Hot Topics

Top