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 ...
you have to add a column and write the formula
=IF(AND(DK=1,AN>85),85,AN)
i hope it may be work
=IF(AND(DK=1,AN>85),85,AN)
i hope it may be work