Forum Discussion
BenBE2
Feb 18, 2022Copper Contributor
Trying to Calculate XNPV with LAMBDA
Does anyone have any idea how to do this? XNPV goes like this: - Rate - CFs (this is a moving range as the formula is dragged) ex. A1:A1 then A1:B1 - Dates (Moving range as the formula is drag...
SergeiBaklan
Feb 18, 2022Diamond Contributor
BenBE2
Feb 18, 2022Copper Contributor
This is a solid idea. I'll give it a shot!