+ Reply to Thread
Results 1 to 3 of 3

Formula's value based off combination of two other cells

  1. #1
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,172

    Formula's value based off combination of two other cells

    Hi,

    I need help modifying my formula to work. I'm trying to have the value of Cell B2 based off the combination value of two other cells.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Formula's value based off combination of two other cells

    hi there kosherboy. your formula does not work at the moment, so it's better to describe to us in words. so if A1 is "Yellow" and A2 is "Blue", you want to show B2 as "Green"? Otherwise, show it as a blank? if so,
    =IF(AND(A1="Yellow",A2="Blue"),"Green","")

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,172

    Re: Formula's value based off combination of two other cells

    Thx, your formula worked perfectly!
    thanks to you I now have a broader understanding in formulas

+ 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. Replies: 1
    Last Post: 01-23-2014, 05:39 AM
  2. Replies: 4
    Last Post: 07-16-2013, 07:44 AM
  3. Enter value in cell based on value combination of two other cells
    By jobell in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2013, 10:40 AM
  4. Projected date formula from a combination of a 2 cells
    By skylinekiller in forum Excel General
    Replies: 3
    Last Post: 08-03-2009, 11:17 AM
  5. How assing unique number in a column based on a combination of two cells
    By galin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2006, 01:30 PM

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