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

x
Solved

# additional step to nested if formula

Posted on 2014-04-08
Medium Priority
169 Views
Hi Experts excel 2007

Formula work fine... =IF(C2="Completed","Complete",IF(C2<>"",C2,IF(C2="",VLOOKUP(A2,H12:L19,2,FALSE))))

Need to add the following. ..if c2 is blank and a2 then blank...before the look up
0
Question by:route217
1 Comment

LVL 8

Accepted Solution

Naresh Patel earned 2000 total points
ID: 39985407
=IF(C2="Completed","Complete",IF(C2<>"",C2,IF(AND(C2="",A2=""),"",IF(C2="",VLOOKUP(A2,H12:L19,2,FALSE)))))
0

## Featured Post

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
###### Suggested Courses
Course of the Month12 days, 20 hours left to enroll