Formula Error Flags (2003 SP3)

Topic

New Reply

Can someone explain why there are error flags in E3:E55 and L15:N64 of the attached worksheet?
T.I.A.

Reply | Quote

Replies

I notice the formula in the L column changes at L14. L15 starts a different formula.

Don’t know about the E column.

Reply | Quote

Column E: dates are stored as numbers in Excel. The formula in E3 contains SUM(B3:D3), so Excel wonders why you didn’t use SUM(A3:D3) since A3 is a number too.

Column L: the formula in L14 is

=IF($J14=0,0,G14+L13)

while that in L15 is

=IF($J15=0,0,SUM(G4:G15))

In this case, Excel wonders why you don’t sum all the way down: SUM(G14:G55).

Sometimes, artificial intelligence is more like artificial stupidity.

Reply | Quote

Sometimes, artificial intelligence is more like artificial stupidity.

Thank you Hans.

Reply | Quote