Forum Discussion
Solved
Conditional column-IFAND function
How to write these condition in conditional column and add column =IF(AND(A2<A3, A2<100), A2, "The value is out of range")
you should create calculation column:
calculation column name =IF(AND([column A2]<[column A3], [column A2]<100), [column A2], "The value is out of range")if I answered at your question please mark topiс as resolved 🙂
where can i find Calculation column option, is it same like custom calculation?
SolomonovAnton
Super User
Super Userif I answered at your question please mark topiс as resolved 🙂