Formula Not Displaying Negative Values Correctly

Hey all,

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

Screenshot 2023-08-04 at 15.07.06.pngScreenshot 2023-08-04 at 15.07.13.png

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.

Question asked here also: https://www.mrexcel.com/board/thread...ectly.1242561/

Sure!

Hoping it's attached

You have circular references: hence the zero result

e.g in N4

=IF(N4<0,0,SUM(H4-B4))

Similar in O4

You can't have a formula and a manually-entered value in the same cell (N4).

Why not just this in N4 copied across?

=H4-B4

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	N	O	P	Q	R
3	One	Two	Three	Four	Total
4	£100.00	-£100.00	-£100.00	£0.00	-£100.00

Sheet: Sheet1

The value in N4 does a calculation from the left side of spreadsheet, and anything above 0 should be carried across to O4 and taken off that amount

Try

in N4

=SUM($H$4:H4)-SUM($B$4:B4)

copy across to Q

then R4=Q4

This works fine, but I want anything above 0 to be deducted from the next row.

Show us the results you want, NOT a non-working formula.

Please show us the results you want in cells N4 to R4 - put them in manually.

N4=300-200=100


O4=100-200=-100 + N4 (100) =0

This what the formula does.

Try

Formula:

Please Login or Register  to view this content.