Solved

two more additional step to current if formula

Posted on 2014-03-26
12
196 Views
Last Modified: 2014-03-26
Hi Experts excel 2007

Need to amend current formula to include additional step below
=IF(E2<>"",E2,IF(AND(A2="Closed",B2="crc"),"time out",""))

So if a2 also is pack and b2 is rrc then into c2 out...above formula is 100% prefect.
0
Comment
Question by:route217
  • 4
  • 4
  • 3
  • +1
12 Comments
 
LVL 13

Expert Comment

by:Santosh Gupta
ID: 39955765
Try

=IF(E2<>"",E2,IF(AND(A2="Closed",A2="Pack",B2="rrc",B2="crc"),"time out",""))
0
 

Author Comment

by:route217
ID: 39955773
Hi expert's

If b2is  rrc then out if based on a2 other wise if b2 is crc then time out based on a2..as above formula
0
 
LVL 13

Expert Comment

by:Santosh Gupta
ID: 39955793
Try this..

=IF(E2<>"",E2,IF(OR(A2="Closed",A2="Pack",B2="rrc",B2="crc"),"time out",""))

if not work, pls explain in details or share the example sheet.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

 

Author Comment

by:route217
ID: 39955814
Hi expert

If rrc it has to be out not time out...nearly there unless I am wrong. .only time if crc..
0
 
LVL 8

Assisted Solution

by:itjockey
itjockey earned 100 total points
ID: 39955820
do u mean this
=IF(B2="rrc",A2,IF(B2="crc",IF(E2<>"",E2,IF(AND(A2="Closed",B2="crc"),"time out",""))))

Open in new window

0
 
LVL 8

Expert Comment

by:itjockey
ID: 39955836
as per your very first post
=IF(E2<>"",E2,IF(AND(A2="Closed",B2="crc"),"time out",IF(AND(A2="pack",B2="rrc"),C2)))

Open in new window

0
 
LVL 8

Expert Comment

by:itjockey
ID: 39955839
or this  
=IF(AND(A2="Pack",B2="rrc"),C2,IF(E2<>"",E2,IF(AND(A2="Closed",B2="crc"),"time out","")))

Open in new window

0
 
LVL 13

Accepted Solution

by:
Santosh Gupta earned 300 total points
ID: 39955846
try this

=IF(B2="rrc","No timeout",IF(E2<>"",E2,IF(OR(A2="Closed",A2="Pack",B2="crc"),"time out","")))
0
 
LVL 33

Assisted Solution

by:Rob Henson
Rob Henson earned 100 total points
ID: 39955888
How about:

=IF(E2<>"",E2,IF(AND(A2="Closed",B2="crc"),"time out",IF(AND(A2="Pack",B2="brc"),"out",""))

Thanks
Rob H
0
 

Author Comment

by:route217
ID: 39955943
Hi Gupts
How would I change ur post39955846 so if e2<>"", then rest of  the formula
So remove, E2,

Everything else if fine.m
0
 

Author Comment

by:route217
ID: 39955964
Fixed ...
0
 
LVL 13

Expert Comment

by:Santosh Gupta
ID: 39955967
do you mean by

=IF(B2="rrc","No timeout",IF(OR(A2="Closed",A2="Pack",B2="crc"),"time out",""))
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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.

828 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