• 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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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