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.
route217Asked:
Who is Participating?
 
Santosh GuptaConnect With a Mentor Commented:
try this

=IF(B2="rrc","No timeout",IF(E2<>"",E2,IF(OR(A2="Closed",A2="Pack",B2="crc"),"time out","")))
0
 
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
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
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
 
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 PatelConnect With a Mentor TraderCommented:
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
 
Rob HensonConnect With a Mentor Finance 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
All Courses

From novice to tech pro — start learning today.