Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2011
    Posts
    24
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Can someone explain this to me?

    Hi, I've taken over a spreadsheet from someone who apparently was quite adept at excel. I'm working on a quarterly report which for each month shows date of class, attendance and registrations received, then in a hidden column is a number calculated using this formula as =IF(AND(L38>0,N38<>"CANCELLED"),1,0) which is either a 1 or 0 indicating if that month had a class or not, then in the quarter total column adds these hidden columns to show the number of classes held in that quarter. HELP

  2. #2
    New Lounger
    Join Date
    Oct 2011
    Posts
    24
    Thanks
    4
    Thanked 0 Times in 0 Posts
    also, I saved his original worksheet and all the data EXCEPT for the formulas.........shouldn't this have kept the original worksheet intact?

  3. #3
    New Lounger
    Join Date
    Oct 2011
    Posts
    24
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Sorry, I saved the original worksheet and DELETED all the data EXCEPT for the formulas.

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Maureen,

    I'not sure what you're asking but I can explain the formula.
    The formula tests to see if both Col L is greater than 0, i.e. there were students and if Col N is NOT equal to "Cancelled" if both of these conditions are true AND() then the formula returns a 1 otherwise a 0.

    As for the worksheet remaining intact if you just deleted the data that is true however the formulas will now often cause problems returning #ERROR or #N/A etc.

    Please post back if you need more information. A sanatized copy of the worksheet would be helpful.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Tags for this Thread

Posting Permissions

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