Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

update current if formula

Posted on 2014-03-26
5
Medium Priority
?
142 Views
Last Modified: 2014-03-26
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
Comment
Question by:route217
5 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39955726
If E2 is always text then how can you multiply it with F2?
0
 
LVL 13

Accepted Solution

by:
Santosh Gupta earned 1000 total points
ID: 39955733
Try

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

Author Comment

by:route217
ID: 39955734
Hold on
0
 
LVL 8

Assisted Solution

by:Naresh Patel
Naresh Patel earned 1000 total points
ID: 39955742
=IF(E2<>"",E2,IF(AND(A2="Closed",B2="crc"),"time out",""))
0
 

Author Comment

by:route217
ID: 39955748
Work's
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question