+ Reply to Thread
Results 1 to 4 of 4

I don't know how to expand an algorithm for over 100 cells

  1. #1
    Registered User
    Join Date
    03-23-2023
    Location
    London
    MS-Off Ver
    2021
    Posts
    2

    Question I don't know how to expand an algorithm for over 100 cells

    I have this excel with editable cells which modify the rest based of an algorithm. The file works fine, the problem is when I try to expand the cells in order to go over 100 registers. If I expand the first table to 10000 is okay, but whenever N3 is higher than 100, N10, N11 and N12 give error #?DIV/0!
    I tried everything I know and I can't make it work. The file attached is the original one without modifications, as I don't know what I messed up.

    Thank you very much for your help!!

    Masaniello.xlsx

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: I don't know how to expand an algorithm for over 100 cells

    I have no idea what you're trying to do... but the problem is in algoritmo M103-P103. There if no formula in those cells. When you increase N3 to >100, the formula in algoritmo column N errors out and it all falls over. See algoritmo and your calculations...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    03-23-2023
    Location
    London
    MS-Off Ver
    2021
    Posts
    2

    Re: I don't know how to expand an algorithm for over 100 cells

    Quote Originally Posted by Glenn Kennedy View Post
    I have no idea what you're trying to do... but the problem is in algoritmo M103-P103. There if no formula in those cells. When you increase N3 to >100, the formula in algoritmo column N errors out and it all falls over. See algoritmo and your calculations...
    Thank you for your response. Now N3 works just fine. The problem is when N4 > 100 which gives the error #¡DIV/0!

    Masa mod.xlsx

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: I don't know how to expand an algorithm for over 100 cells

    I still have no idea what this is doing... but you also need to extend algoritmo out to the right.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 04-25-2020, 09:46 AM
  2. How do you expand cells?
    By Drizzle in forum Excel General
    Replies: 3
    Last Post: 01-15-2013, 09:30 PM
  3. expand cells
    By samanthab in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2009, 10:15 AM
  4. Algorithm to change format of specific cells
    By Dave32 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2008, 07:36 PM
  5. [SOLVED] how does one expand individual cells?
    By Brian @ Pease in forum Excel General
    Replies: 1
    Last Post: 11-22-2005, 11:55 AM
  6. [SOLVED] Using the balance sheet template, any way to expand?-way to expand
    By RABBITS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-27-2005, 02:05 PM
  7. Expand and Collapse Cells?
    By fernandes70 in forum Excel General
    Replies: 1
    Last Post: 03-19-2005, 01:50 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1