Improve company productivity with a Business Account.Sign Up

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

update current if formula

Hi Experts excel 2007

I need to amend current if formula to accommodate one additional step

IF(AND(A2="Closed",B2="crc"),"time out","")

so if e2 has a value (always text), then e2 into cell f2 otherwise the above formula. .
0
route217
Asked:
route217
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
If E2 is always text then how can you multiply it with F2?
0
 
Santosh GuptaCommented:
Try

=IF(E3<>"",E2,IF(AND(A2="Closed",B2="crc"),"time out",""))
0
 
route217Author Commented:
Hold on
0
 
Naresh PatelTraderCommented:
=IF(E2<>"",E2,IF(AND(A2="Closed",B2="crc"),"time out",""))
0
 
route217Author Commented:
Work's
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now