Results 1 to 3 of 3

Assigning a value to a cell based on conditions of two other cells being equal

Threaded View

chrisworrell Assigning a value to a cell... 01-11-2011, 02:33 PM
chrisworrell Re: Assigning a value to a... 01-11-2011, 04:48 PM
6StringJazzer Re: Assigning a value to a... 01-11-2011, 04:40 PM
  1. #1
    Registered User
    Join Date
    01-11-2011
    Location
    athens, ga
    MS-Off Ver
    Excel 2003
    Posts
    2

    Assigning a value to a cell based on conditions of two other cells being equal

    Okay I have tried searching and I am just not smart enough to figure out all this programming stuff so I am not exactly sure what to do, but I assume it is simple.

    I have three columns, one is Purchase Size, one is Count Size, and one is Purchase Count.

    I just need a formula that will look at the Purchase Size and Count Size and if they are equal automatically force the Purchase Count to be a value of 1. If they are not equal I need it to allow the user to input the correct amount.

    Both the Purchase Size and Count Size columns utilize a list of possible selections.

    It would be nice to also lock the ability to alter the 1 if the two columns are identical

    Thank you very much
    Last edited by chrisworrell; 01-11-2011 at 04:40 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