if formula based on two conditions

Hi Experts Excel 2007

Need a if formula to do the following
If cell a2 is closed and cell b2 is crc then set c2 to time out.
Closed
Crc  and
Time out are words in cells
route217Asked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
put this formula in C2 and drag it down
=IF(and(A2="closed",B2="crc"),"Time out","")

gowflow
0
 
Naresh PatelConnect With a Mentor TraderCommented:
=IF(AND(A2="Closed",B2="crc"),"time out","")
0
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=IF(AND(A2="closed",B2="crc"),"Time out","")
0
 
Naresh PatelTraderCommented:
ooppss dint refresh browser as you can see there is 6 sec time difference.
0
 
route217Author Commented:
Thank u all experts..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.