Forum Discussion

BenBE2's avatar
BenBE2
Copper Contributor
Feb 18, 2022

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...

Resources