+ Reply to Thread
Results 1 to 7 of 7

Formulae Input/output help please

  1. #1
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Formulae Input/output help please

    hello

    I am trying to build a formulae that looks at combination of X,Y,z and return a pre defined output , the input values are in Column E,F,G

    can you see where I went wrong please ?

    Thank you



    Please Login or Register  to view this content.
    Last edited by bimo; 12-03-2014 at 02:32 AM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Formulae Input/output help please

    What is the input values of arguments xyz?

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Formulae Input/output help please

    Quote Originally Posted by :) Sixthsense :) View Post
    What is the input values of arguments xyz?

    Please Login or Register  to view this content.
    these are the input values

    "high", "Low"

    "men", "women", "boys"

    "shoes", "socks", "trouser", "hat"

    Thanks

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Formulae Input/output help please

    Something like this might be what you are looking for

    Please Login or Register  to view this content.
    Last edited by mikerickson; 12-03-2014 at 04:23 PM.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Formulae Input/output help please

    Use Select Case Like this

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Formulae Input/output help please

    Quote Originally Posted by :) Sixthsense :) View Post
    Use Select Case Like this

    Please Login or Register  to view this content.
    Smashing! Thank you

  7. #7
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Formulae Input/output help please

    Quote Originally Posted by mikerickson View Post
    Something like this might be what you are looking for

    Please Login or Register  to view this content.
    Brillian!! Thank you

+ 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. [SOLVED] Transferring of input from input cell to output cells
    By bebongtheshark in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-09-2014, 01:28 AM
  2. [SOLVED] input dob / input certain age / output date at certain age
    By Alastair77 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-12-2014, 09:36 AM
  3. Need a formulae that will check x against y and input z!!
    By Jaithorn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2013, 09:58 PM
  4. find last input row.. copy down block of formulae to this row.
    By niceguy21 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-07-2012, 11:17 AM
  5. Input to Output
    By Rural Nutty in forum Excel General
    Replies: 4
    Last Post: 08-12-2008, 11:17 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