Need help backtracking and figuring out what this conditional formula means in words.

[iceshark17]

I am applying a formula from one existing project to a new project with similar data, but need to understand the formula so that I may see if any changes must be made to accomodate the new project:

=IF(OR(C2=0,C2="",D2=0,D2=9999),"",(D2+(IF(AND(C2="ACP",B2<=8),REF_SHEET!$B$9,VLOOKUP(C2,REP_LIFE!$A$7:$B$21,2,0)))-REF_SHEET!$B$23))

I prefer to keep it vague and speak in terms of the names of the cells rather than the content inside of it.

Could someone please provide a translation that would look something like:

if C2 is equal to "0" or no entry, or D2 is equal to "0" or "9999", then the answer is "_". Otherwise, the answer is "D2 + 'X' if so and so is true..."

I've been staring at this formula for a few hours now and it's got me all sorts of confused.

Thank you in advance for anyone taking the time to see if they could help.

 

[dermie_72]

you're pretty much right on the money.
If C2 meets any of the following criteria the result will be a blank cell.
C2 is 0, or blank OR D2 is 0, or 9999.
If it non of these values appear in C2 or D2, then does the following
Whatever value in D2 +
the value of the VLOOKUP. The vlookup is depended on
If C2 = ACP AND B2<=8. If it meets BOTH of those criteria, it will vlookup(C2,rep_life!A7:B21,2,0)
If C2 =ACP and B2 <=8 is not met, it ignores the vlookup.
D2+vlookup (if AND statement is met)-ref_sheetB23 value

hope that helps.

 

[iceshark17]

Thank you Dermie. I wish I could buy you a beer.