Don't Understand Code

M

miracleblake

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)
 
M

miracleblake

The value in field AI13 is 15.0

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

$D13 + 23 )))/1000.
 
J

JE McGimpsey

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.





miracleblake
 
Top