Compare values and return Boolean value

[krishna09]

Hello Team,

Hope you all are doing well!

So I'm trying to automate our metrics sheet where the data in it contains SLA in hours 1,5,24 respectively in one column -- Lets say Column A.

In the other column -- column B, I've the actual time taken to complete the task.

Following are the conditions:

1. If A=1 & B >1.5, return NotMet, else return Met
2. If A=5 & B>5.5, return NotMet, else return Met
3. If A=24 & B>5.5, return Non Met, else return Met

Sample Data:

A B C = Output bolean Met/NotMet
1 2.3 Formula?
5 3.1
24 4.5
1 5
5 6.9
24 0.79

Could you help me with a formula where I can get the output required?

Thank you for looking into it.

Looking forward to your response.

Best,

Krishna

[JohnTopley]

Try

=IF(OR(AND(A1=1,B1>1.5),AND(A1=5,B1>5.5),AND(A1=24,B1>5.5)),"NotMet","Met")

[TMS]

Try:

Please Login or Register  to view this content.

[TMS]

Sorry for the echo; getting slow in my old age. Trying to type a formula on an iPad doesn't help

[JohnTopley]

or ...

=IF(AND(OR($A2=1,$A2=5,$A2=24),$B2>5.5),"NotMet","Met")

[Phuocam]

or try ...
=IF(OR(AND(A1=1,B1>1.5),AND(B1>5.5,OR(A1={24,5}))),"NotMet","Met")

[krishna09]

Hello Team,

That's brilliant! Thanks a lot for your support. That was really quick.

The issue is now resolved.

I tried to find the formula since few days, but in vain. It's always better to talk to the correct person(s).

Could you please share a website where I can understand and write formulas in Excel.

Best,

Krishna

[JohnTopley]

Search the net but here is one site:

http://www.free-training-tutorial.com/edit.html

As your problem has been addressed, can you please mark the thread as solved ("Thread Tools" at top of first post).