Solved

update current if formula

Posted on 2014-03-26
5
136 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 250 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:itjockey
itjockey earned 250 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
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 demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

679 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