Excel Functions of the Day
Some of the formulas I came up with at work today:
=ROUND(IF(ISNA(VLOOKUP(A565,'[Active and TV RIAs 7-1-08.xls]renderReports'!$G$8:$AB$166,22,FALSE)),0,
VLOOKUP(A565,'[Active and TV RIAs 7-1-08.xls]renderReports'!
$G$8:$AB$166,22,FALSE)),2)
=IF(DAY(L564)=1,12*(YEAR($I$1)-YEAR(L564))+(MONTH($I$1)-MONTH(L564)),12*(YEAR($I$1)-YEAR(L564))+(MONTH($I$1)-MONTH(L564))-1)
(The first one looks up some number in a completely different file and places it in the file I'm working on; the second one counts how many whole months there are between two dates, which can be tricky if one date is in the middle of the month and the other is at the beginning of the month.)
I'm learning so much!
=ROUND(IF(ISNA(VLOOKUP(A565,'[Active and TV RIAs 7-1-08.xls]renderReports'!$G$8:$AB$166,22,FALSE)),0,
VLOOKUP(A565,'[Active and TV RIAs 7-1-08.xls]renderReports'!
$G$8:$AB$166,22,FALSE)),2)
=IF(DAY(L564)=1,12*(YEAR($I$1)-YEAR(L564))+(MONTH($I$1)-MONTH(L564)),12*(YEAR($I$1)-YEAR(L564))+(MONTH($I$1)-MONTH(L564))-1)
(The first one looks up some number in a completely different file and places it in the file I'm working on; the second one counts how many whole months there are between two dates, which can be tricky if one date is in the middle of the month and the other is at the beginning of the month.)
I'm learning so much!
Labels: work
posted by Dave at
11:00 PM
0 Comments
