Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# two more additional step to current if formula

Posted on 2014-03-26
Medium Priority
207 Views
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
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
• 4
• 4
• 3
• +1

LVL 13

Expert Comment

ID: 39955765
Try

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

Author Comment

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

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

Author Comment

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

Naresh Patel earned 400 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",""))))
``````
0

LVL 8

Expert Comment

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)))
``````
0

LVL 8

Expert Comment

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

LVL 13

Accepted Solution

Santosh Gupta earned 1200 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

Rob Henson earned 400 total points
ID: 39955888

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

Thanks
Rob H
0

Author Comment

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

ID: 39955964
Fixed ...
0

LVL 13

Expert Comment

ID: 39955967
do you mean by

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

## Featured Post

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.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will diâ€¦
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a â€¦
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
###### Suggested Courses
Course of the Month9 days, 3 hours left to enroll