Maximum Drawdown always returns 0

[Sire]

Using latest Excel 2301 I always get 0 from the MaxDrawDown function. Tried with integers and decimal numbers.

[mayest]

I just tried it with the attached Excel file and it seems to work for me.
MaxDrawdown Example.xlsx

[Sire]

Ah my bad, I didn't know it expected change (P/L) with negative numbers. I tried with portfolio balances like 100, 90 - which one could argue it should still compute.

There also seem to be an issue with using negative integers. Using negative percentages works, strangely. See attached.

MaxDrawdown.Example.xlsx

[mayest]

I'm not sure why your example of 10, -3, -3 isn't working correctly. Seems like it should. I'll look into this if I get time. In the meantime, just be sure that you are feeding percentage returns into the function.