Solved

if formula slight amendment

Posted on 2014-03-26
3
147 Views
Last Modified: 2014-03-26
Hi Experts  excel 2007

Need to amend current formula
IF(B2="rrc","No timeout",IF(E2<>"",E2,IF(OR(A2="Closed",A2="Pack",B2="crc"),"time out","")))

To include additional step/criteria
So if e2 is "" empty and a2 close b2 pack then time...leave if e2 <>"", e2 step also need this too.
0
Comment
Question by:route217
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
Santosh Gupta earned 500 total points
ID: 39956004
Try below...
=IF(AND(E2="",A2="Close",B2="pack"),"timeout",IF(B2="rrc","No timeout",IF(E2<>"",E2,IF(OR(A2="Closed",A2="Pack",B2="crc"),"time out",""))))
0
 

Author Comment

by:route217
ID: 39956010
Feedback...Great

Just need to amend...so if a2 is anything other than closed or pack. ..then blank..so if I have apples in a2 treat a2 as a blank cell...
0
 

Author Comment

by:route217
ID: 39956025
Worked it out....Thanks appreciate the fantastic feedback...5 stars to experts here
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

829 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