Forum Discussion
Using If Formulas to Mass Edit Certain Data and Leave Other Data Alone
I know it’s a wordy title, but I have a dilemma and I’m not sure how to solve it. To make it simple, I have two columns: AN (ratings) and DK (position)
If the conditions of DK=1 AND any cell in AN > 85 are met, I want to change the value of that cell only to 85. My issue is I don’t know how to do so without changing the data of the rest of the column.
If the conditions of DK=1 AND any cell in AN > 85 are met, I want to change the value of that cell only to 85. My issue is I don’t know how to do so without changing the data of the rest of the column.
1 Reply
- you have to add a column and write the formula
=IF(AND(DK=1,AN>85),85,AN)
i hope it may be work
