Improve company productivity with a Business Account.Sign Up

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

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
Asked:
route217
  • 4
  • 4
  • 3
  • +1
3 Solutions
 
Santosh GuptaCommented:
Try

=IF(E2<>"",E2,IF(AND(A2="Closed",A2="Pack",B2="rrc",B2="crc"),"time out",""))
0
 
route217Author 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
 
Santosh GuptaCommented:
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
route217Author Commented:
Hi expert

If rrc it has to be out not time out...nearly there unless I am wrong. .only time if crc..
0
 
Naresh PatelTraderCommented:
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
 
Naresh PatelTraderCommented:
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
 
Naresh PatelTraderCommented:
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
 
Santosh GuptaCommented:
try this

=IF(B2="rrc","No timeout",IF(E2<>"",E2,IF(OR(A2="Closed",A2="Pack",B2="crc"),"time out","")))
0
 
Rob HensonFinance AnalystCommented:
How about:

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

Thanks
Rob H
0
 
route217Author 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
 
route217Author Commented:
Fixed ...
0
 
Santosh GuptaCommented:
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 4
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now