Closed Thread
Results 1 to 2 of 2

too many IF AND Functions HELP

  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    Portland,OR
    MS-Off Ver
    Excel 2010
    Posts
    49

    too many IF AND Functions HELP

    Guys,

    I'm new here and need some help with a thickness calculator i'm working on. I have 4000 if and functions per line in my worksheets there has got to be a better way as the file gets way to big. I have material and based on the material a thickness comes up then you type in if the resin content is plus or minus a certain percent based on that the thickness changes this is different for different material and each material has different glass types. I need shorter code. I've posted my worksheet thanks for any help. There is only 4 - 8 layers due to size so you can only choose 4 6 or 8 thanks. Can I use vba code or anything besides what I have now. I need this to go up to 50 layers and at 8 the worksheet is getting to big.

    Much Thanks,

    CW
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    Re: too many IF AND Functions HELP

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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