Results 1 to 4 of 4

IF THEN statement and Tables

Threaded View

markmkramer IF THEN statement and Tables 10-25-2012, 03:52 PM
ChemistB Re: IF THEN statement and... 10-25-2012, 04:06 PM
markmkramer Re: IF THEN statement and... 10-25-2012, 04:17 PM
ChemistB Re: IF THEN statement and... 10-25-2012, 05:17 PM
  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2010
    Posts
    17

    IF THEN statement and Tables

    I am attempting to create a table in excel that will automatically fill out another table depending on the outcome. For example, if A3> 0, then A1, but if it is not, then check A4>0, then A4, etc. I've attempted it in this manner so far, but when I get past the first one I always seem to get repeating outcomes. For example, if A1=0 and A2=0 , then it will move to A3 but A1 and A2 will have the same result as A3.

    If you don't understand, then I will try to elaborate or show a photo.
    Last edited by markmkramer; 10-25-2012 at 06:07 PM.

Thread Information

Users Browsing this Thread

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

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