I need to update the following Excel 2010 Formulas

IF D200=M, THEN:

=IFERROR(INDEX('[Report 7-29-14.xlsx]Projects'!$D$10:$D$150,MATCH($A10,'[Report 7-29-14.xlsx]Projects'!$A$10:$A$150,0))&"","")

IF NOT, THEN:
=IFERROR(IF(F10="","",LEFT(F10,FIND("(E)",F10)+2)) & IFERROR(CHAR(10) & IF(AN10="","",TEXT(AN10,"M/D/YY")&" (A)"),""),"")



IF F200=M, THEN:

=IFERROR(INDEX('[Report 7-29-14.xlsx]Projects'!$F$10:$F$150,MATCH($A10,'[Report 7-29-14.xlsx]Projects'!$A$10:$A$150,0))&"","")

IF NOT, THEN:
=IFERROR(IF(X10="","",TEXT(WORKDAY(LEFT(G10, LEN(G10)-4),-10-ROUND(X10/IF(X10<=1500,175,300),0)),"m/d/yy")&" (E)"),"")




IF G200=M, THEN:

=IFERROR(INDEX('[Report 7-29-14.xlsx]Projects'!$G$10:$G$150,MATCH($A10,'[Report 7-29-14.xlsx]Projects'!$A$10:$A$150,0))&"","")

IF NOT, THEN:
=IF(I10="","",TEXT(I10,"M/D/YY")&" (E)")
LVL 1
wrt1meaAsked:
Who is Participating?
 
sentnerConnect With a Mentor Commented:
The if/then is handled with an "=if()" function call.  The syntax is:

=IF(<statement>, <do something for true>, <do something for false>)

The statement portion would be the condition such as D200="M" (make sure you put text values in quotes).

So for your example, you should be able to do something like:
=IF(D200="M", IFERROR(INDEX('[Report 7-29-14.xlsx]Projects'!$D$10:$D$150,MATCH($A10,'[Report 7-29-14.xlsx]Projects'!$A$10:$A$150,0))&"",""), IFERROR(IF(F10="","",LEFT(F10,FIND("(E)",F10)+2)) & IFERROR(CHAR(10) & IF(AN10="","",TEXT(AN10,"M/D/YY")&" (A)"),""),""))

Open in new window

0
 
sentnerCommented:
You say you need to update the formulas, but didn't ask a question about what help you need...
0
 
wrt1meaAuthor Commented:
I am needing help on updating existing formulas...getting the context right is my problem. If D200=M, then the formula runs through the first one. If not, it runs the second one....

IF D200=M, THEN:

=IFERROR(INDEX('[Report 7-29-14.xlsx]Projects'!$D$10:$D$150,MATCH($A10,'[Report 7-29-14.xlsx]Projects'!$A$10:$A$150,0))&"","")

IF NOT, THEN:
=IFERROR(IF(F10="","",LEFT(F10,FIND("(E)",F10)+2)) & IFERROR(CHAR(10) & IF(AN10="","",TEXT(AN10,"M/D/YY")&" (A)"),""),"")
0
 
wrt1meaAuthor Commented:
Thank you very much....I kept adding additional IFERROR's upfront, instead of using IF.

Plus a couple of other minuscule things, commas and parenthesis. Thanks for the help!
0
All Courses

From novice to tech pro — start learning today.