x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 222

# two more additional step to current if formula

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
route217
• 4
• 4
• 3
• +1
3 Solutions

Commented:
Try

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

Author Commented:
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

Commented:
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 Commented:
Hi expert

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

do u mean this
``````=IF(B2="rrc",A2,IF(B2="crc",IF(E2<>"",E2,IF(AND(A2="Closed",B2="crc"),"time out",""))))
``````
0

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

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

Commented:
try this

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

Finance AnalystCommented:

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

Thanks
Rob H
0

Author Commented:
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 Commented:
Fixed ...
0

Commented:
do you mean by

=IF(B2="rrc","No timeout",IF(OR(A2="Closed",A2="Pack",B2="crc"),"time out",""))
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.