+ Reply to Thread
Results 1 to 5 of 5

An 'If Then' Formula

  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Exclamation An 'If Then' Formula

    Here is my situation:

    Cells A1 to A3 are numbered 1-3.
    Cells A4 to A6 are empty.
    Cells A7 to A9 are numbered 4-6 if a number higher than 1 is entered into Cell C1.

    I need a formula to do the following:

    If the number 4 is entered into Cell A4, Cells A7 to A9 should now display the numbers 5-7, but only if a number higher than 1 is entered into Cell C1.

    If the number 4 is entered into Cell A4 and the number 5 is entered into Cell A5, Cells A7 to A9 should now display the numbers 6-8, but only if a number higher than 1 is entered into Cell C1.

    If the number 4 is entered into Cell A4 and the number 5 is entered into Cell A5 and the number 6 is entered into Cell A6, Cells A7 to A9 should now display the numbers 7-9, but only if a number higher than 1 is entered into Cell C1.

    Is there any formula that can do this? Any help would be greatly appreciated.

  2. #2
    Valued Forum Contributor Dunc3142's Avatar
    Join Date
    09-05-2007
    Location
    Franklin OH
    MS-Off Ver
    2000 and 2007 and 2010 @ Home & Teach 2010
    Posts
    351

    I think this is what you are after

    Let me know.
    Attached Files Attached Files
    Yes it will. we just have to figure out how...
    If I have helped you, PLEASE click the * and add to my Rep.
    Also, if the problem is SOLVED please mark it as so.

  3. #3
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Exclamation It Needs To Work For Alphabets

    Thank you very much. Now I realized that I actually need a formula for alphabets instead of numbers -

    Cells A1 to A3 contain the letters A-C.
    Cells A4 to A6 are empty.
    Cells A7 to A9 contain the letters D-F if a number higher than 1 is entered into Cell C1.

    I need a formula to do the following:

    If the letter D is entered into Cell A4, Cells A7 to A9 should now display the letters E-G, but only if a number higher than 1 is entered into Cell C1.

    If the letter D is entered into Cell A4 and the letter E is entered into Cell A5, Cells A7 to A9 should now display the letters F-H, but only if a number higher than 1 is entered into Cell C1.

    If the letter D is entered into Cell A4 and the letter E is entered into Cell A5 and the letter F is entered into Cell A6, Cells A7 to A9 should now display the letters G-I, but only if a number higher than 1 is entered into Cell C1.

    Is there a formula for that?

  4. #4
    Valued Forum Contributor Dunc3142's Avatar
    Join Date
    09-05-2007
    Location
    Franklin OH
    MS-Off Ver
    2000 and 2007 and 2010 @ Home & Teach 2010
    Posts
    351

    Try again

    Re-done
    See if this works
    Attached Files Attached Files

  5. #5
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    838

    Exclamation So Far So Good

    That's works well - I'm just having a slight problem getting the formulas to work on my worksheet. I've attached it so you can see what I'm trying to do. I'd like to have column B on your sheet starting on column AL on my sheet. The green cell is your C1 cell, the red cells are your cells A4-A6, and the yellow cells are your cells A7 and up.
    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)

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