Don't Understand Code

Can anyone help me to understand this code? I am confused about which table information is coming from, as well as the sum function?

=IF($F13="CV",SUM((AI13)*(VLOOKUP((VALUE(T_DATE_YEAR)-3)&$C13,'C:\COST ESTIMATE WORKSHEET\CEW REF.XLS'!PAYSCALE,$D13+23)))/1000,0)

Pretty simple.


If F13 has the value "CV"
multiply AI13 by the value looked up
Else
set to 0
End

--

HTH

RP
(remove nothere from the email address if mailing direct)


"miracleblake" <[email protected]>
wrote in message
news:[email protected]...
>
> Can anyone help me to understand this code? I am confused about which
> table information is coming from, as well as the sum function?
>
> =IF($F13="CV",SUM((AI13)*(VLOOKUP((VALUE(T_DATE_YEAR)-3)&$C13,'C:\COST
> ESTIMATE WORKSHEET\CEW REF.XLS'!PAYSCALE,$D13+23)))/1000,0)
>
>
> --
> miracleblake
> ------------------------------------------------------------------------
> miracleblake's Profile:
http://www.excelforum.com/member.php...o&userid=29487
> View this thread: http://www.excelforum.com/showthread...hreadid=491890
>

The value in field AI13 is 15.0

How does the second section equate. Unclear: The information based off of another worksheet (CEW REF.XLS)

$D13 + 23 )))/1000.0

First

=IF($F13="CV", TRUE branch, FALSE branch)

The FALSE branch is 0, so if $F13<>"CV", the function will return 0.

If $F3 does = "CV":

SUM(...)/1000

the SUM() is superfluous and can be eliminated. The result of

AI13 * VLOOKUP(X, Y, Z)

is divided by 1000.

The VLOOKUP searrches for X in the first column of table Y, and returns
the corresponding value found in column Z of table Y.

X = (VALUE(T_DATE_YEAR)-3) & $C13
hard to know what T_DATE_YEAR is: it could be a value expressed as a
defined name, or it could be a reference to a cell which contains a
value. See Insert/Name/Define to see its definition.

Y = PAYSCALE is a named range in workbook 'CEW REF.XLS' in directory
C:\COST ESTIMATE WORKSHEET. Open that workbook, use Insert/Name/Define
to find out what range is referred to.

Z = $D13 + 23, which should be pretty straightforward.





In article <[email protected]>,
miracleblake
<[email protected]> wrote:

> Can anyone help me to understand this code? I am confused about which
> table information is coming from, as well as the sum function?
>
> =IF($F13="CV",SUM((AI13)*(VLOOKUP((VALUE(T_DATE_YEAR)-3)&$C13,'C:\COST
> ESTIMATE WORKSHEET\CEW REF.XLS'!PAYSCALE,$D13+23)))/1000,0)