New 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 dragged) ex. A2:A2 then A2:B2

I think i use the Map function but I can quite get it to work. Can anybody assist?

2 Replies

# Re: Trying to Calculate XNPV with LAMBDA

Perhaps something like this

which you may customize and wrap by lambda

# Re: Trying to Calculate XNPV with LAMBDA

This is a solid idea. I'll give it a shot!