[2 days left] Whatâ€™s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# if formula based on two conditions

Posted on 2014-03-26
Medium Priority
143 Views
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
0
Question by:route217
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 31

Accepted Solution

gowflow earned 668 total points
ID: 39955653
put this formula in C2 and drag it down
=IF(and(A2="closed",B2="crc"),"Time out","")

gowflow
0

LVL 8

Assisted Solution

Naresh Patel earned 668 total points
ID: 39955654
=IF(AND(A2="Closed",B2="crc"),"time out","")
0

LVL 43

Assisted Solution

Saqib Husain, Syed earned 664 total points
ID: 39955655
=IF(AND(A2="closed",B2="crc"),"Time out","")
0

LVL 8

Expert Comment

ID: 39955657
ooppss dint refresh browser as you can see there is 6 sec time difference.
0

Author Comment

ID: 39955698
Thank u all experts..
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
###### Suggested Courses
Course of the Month13 days, 12 hours left to enroll