Formula Not Showing Negative Values Correctly

[Frankinstyyn]

Hey all,

I have written 3 formulas that all work perfectly and show the correct value on the formula builder - screenshot below.

As you can see on the bottom: Result: -1834.94 & -820.4 - that's the correct numbers, but on my spreadsheet the both show £0.00.

I've tried changing the number format, but no joy..

Any help would be really appreciated, thanks.

 

[Fluff]

Looks like you have an answer on EF, let us know if that works or not.