?
Solved

if formula based on two conditions

Posted on 2014-03-26
5
Medium Priority
?
146 Views
Last Modified: 2014-03-26
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
Comment
Question by:route217
5 Comments
 
LVL 31

Accepted Solution

by:
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

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

Assisted Solution

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

Expert Comment

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

Author Comment

by:route217
ID: 39955698
Thank u all experts..
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question