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

x
Solved

# tricky if formula

Posted on 2014-03-25
Medium Priority
176 Views
Hi Experts excel 2007

I have the following if formula
=IF(OR(G2="",G2<TODAY()),AA2,IF(A2="",IF(C2="","",C2),VLOOKUP(A2,sheet2!\$A\$2:\$B\$20,2,FALSE)))

which need amending to do the if g2 is blank then c2, if g2 has a date less then todays date as above then the above formula..
0
Question by:route217

LVL 9

Accepted Solution

BlueYonder earned 2000 total points
ID: 39953118
try this formula

IF(ISBLANK(G2), C2, IF(G2<TODAY(),AA2,IF(A2="",IF(C2="","",C2),VLOOKUP(A2,sheet2!\$A\$2:\$B\$20,2,FALSE))))
0

Author Comment

ID: 39953128
Stop in .....5 star feedback.
0

## Featured Post

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
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 …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
###### Suggested Courses
Course of the Month12 days, 14 hours left to enroll