Formula Help

Occasional Visitor

Hello Excel Wizards,

 

Need your help to create a formula wherein i need to populate the comment as breach where the variance is greater than or equal to +25 and Less than or equal to -25.

 

Business FunctionVariance
KLMN-24
MNKL25
JKLM60
LLMJ-21
TYUU-66
1 Reply

@itssreeji 

=IF(OR(B2>=25,B2<=-25),"breach","")

Is this what you want to do?

comment.JPG