+ Reply to Thread
Results 1 to 1 of 1

If Formula (multiconditon) Auto Generate When add a value

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,005

    Post If Formula (multicondition) Auto Generate When add a value

    hello evryone

    1 = I have a range of (G10:G1500). In this range i add data in number like(50 to 450)..
    2 = In range (I10:I1500) I have words like (BC, J, JT, VC)
    3 = In range (R10:R1500) i want the result according the below condition


    Condition 1 = If Cell (I10) = (HB)
    and
    Cell (G10) = (178 to 500) Number
    then want answer in cell (R10) result 1= "HBC"

    and
    Cell (G10) = (158 to 177) Number
    then want answer in cell (R10) result 2= "LBC"

    and
    Cell (G10) = (100 to 157) Number
    then want answer in cell (R10) result 3= "HBC"

    and
    Cell (G10) = (50 to 99) Number
    thenwant answer in cell (R10) result 3= "VC"


    And other words (J, JT, VC) have above same condition

    e.g if Cell I10 = JT then RESULT 1 = HJT, RESULT 2 = LJT, RESULT 3 = SLJT

    e.g if Cell I10 = J then RESULT 1 = HT, RESULT 2 = LT, RESULT 3 = SLJ

    and formula auto generate according to cell range(G10:G1500)
    i mean if i type in Cell "G11" then result according to Cell "I11" should be in Cell "R11" and continue....
    thanx a lot

    I use this formula in excel
    Please Login or Register  to view this content.
    Y3 = number what ever i want
    Y5 = number what ever i want
    Y4 = number what ever i want

    AA3 = number what ever i want
    AA5 = number what ever i want
    AA4 = number what ever i want

    AC3 = number what ever i want
    AC5 = number what ever i want
    AC4 = number what ever i want
    Last edited by HaroonSid; 03-30-2014 at 06:42 AM.

+ 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. Generate Auto ID
    By Shazz in forum Excel General
    Replies: 8
    Last Post: 05-03-2013, 06:23 AM
  2. Auto generate value
    By gjrscotland in forum Excel General
    Replies: 2
    Last Post: 04-02-2013, 11:27 AM
  3. help in formula to auto generate
    By kkqlee in forum Excel General
    Replies: 1
    Last Post: 02-06-2012, 11:05 AM
  4. formula to generate month-to-date based on auto date
    By infinitysales in forum Excel General
    Replies: 1
    Last Post: 06-27-2008, 01:09 AM
  5. Auto Generate a new row
    By fanny_magnet in forum Excel General
    Replies: 0
    Last Post: 04-28-2005, 11:29 AM

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