Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    Can someone explain why there are error flags in E3:E55 and L15:N64 of the attached worksheet?
    T.I.A.
    Attached Files Attached Files
    Regards
    Don

  2. #2
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I notice the formula in the L column changes at L14. L15 starts a different formula.

    Don't know about the E column.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Column E: dates are stored as numbers in Excel. The formula in E3 contains SUM(B33), so Excel wonders why you didn't use SUM(A33) 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.

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='HansV' post='777147' date='27-May-2009 08:44']Sometimes, artificial intelligence is more like artificial stupidity.[/quote]
    Thank you Hans.
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •